Muaj ntau qhov laj thawj uas koj yuav xav nrhiav cov hnub lossis hli thiab xyoo nruab nrab ntawm ob hnub. Nov yog qhov koj tuaj yeem ua nws siv MS Excel.
Cov kauj ruam
Kauj Ruam 1. Qhib MS Excel
Kauj Ruam 2. Ntxiv hnub pib rau hauv ib lub xovtooj thiab hnub kawg mus rau lwm qhov
Nco ntsoov muab nws ua "Hnub", tsis yog cov ntawv yooj yim lossis lwm yam.
Kauj Ruam 3. Xaiv lub cell tso zis
Ntawm no koj yuav sau cov qauv yooj yim zoo nkauj los xam qhov sib txawv ntawm cov hnub.
Kauj Ruam 4. Hloov mus rau tus lej bar
Ntawm no, sau = DATEDIF (A1, B1, "d") (A1 yog lub xov tooj ntawm tes nrog pib hnub thiab A2 nrog hnub kawg.) Nws yuav tso tawm cov hnub nruab nrab ntawm ob hnub.
- Cov syntax yog: = DATEDIF (start_date, end_date, mode)
-
Ntau hom uas tuaj yeem siv tau yog "m", "y", "d", "ym", "yd", "md".
- "m" hais txog tsuas yog lub hlis.
- "y" hais txog tsuas yog xyoo.
- "d" hais txog tsuas yog hnub tim.
- "ym" lim tawm cov xyoo tshwj xeeb thiab xa rov qab lub hlis sib txawv ntawm cov hnub zoo li ob xyoos zoo ib yam.
- "yd" lim tawm xyoo tshwj xeeb thiab rov qab hnub sib txawv ntawm cov hnub zoo li yog ob xyoos zoo ib yam.
- "md" lim tawm lub hli tshwj xeeb thiab rov qab hnub sib txawv ntawm cov hnub zoo li ob lub hlis zoo ib yam.
Kauj Ruam 5. Siv cov mis hauv lwm cov qauv, yog tias xav tau
Koj tuaj yeem txuas cov hlua tsim nyog los ua cov mis ntau yam. Ib daim ntawv thov sib xws yog teev cov xyoo, hli thiab hnub nruab nrab ntawm ob hnub tshwj xeeb los ntawm kev siv cov mis: