Microsoft Excel yog qhov program muaj zog. Yog tias koj siv nws los tsim daim ntawv qhia hnub, lossis lwm yam uas koj yuav xav nrhiav hnub tim 1, 2, lossis 3 lub hlis tom ntej, ntawm no yog cov qauv uas koj tuaj yeem siv.
cov kauj ruam
Kauj Ruam 1. Qhib koj lub computer thiab qhib daim ntawv Excel
Kauj Ruam 2. Hauv txhua lub xovtooj, rau qhov piv txwv no peb yuav siv cell A2, sau koj hnub tim
Ej.: 1/1/2006
Kauj Ruam 3. Hauv lwm lub xovtooj sib txawv, rau qhov piv txwv no, peb siv cell B2, nkag mus rau lub hli uas A2 yuav nce ntxiv
Ej.: 5.
Kauj Ruam 4. Hauv lub cell kawg, ntaus cov mis:
= HNUB (YEAR (A2), MONTH (A2)+B2, MIN (HNUB (A2), HNUB (HNUB (YEAR (YEAR (A2)), HLI (A2)+B2+1, 0))))) hloov A2 thiab B2 nrog cov hlwb sib xws ntawm koj daim ntawv nthuav qhia.
Kauj Ruam 5. Koj yuav pom tias lub xov tooj ntawm tes tam sim no yuav muaj qhov xav tau laij tawm
Kauj Ruam 6. Lwm qhov kev xaiv yog siv = EDATE (start_date, hli)
Nov yog txoj hauv kev yooj yim dua, tab sis nws tsuas tuaj yeem siv yog tias Kev Ntsuam Xyuas ToolPak tau teeb tsa.