Microsoft Excel yog qhov program muaj zog. Yog tias koj siv nws rau daim ntawv qhia hnub lossis lwm yam uas koj yuav xav pom hnub tim 1, 2, lossis 3 lub hlis tom qab lwm hnub ntawm no yog tus lej uas koj tuaj yeem siv.
Cov kauj ruam
Kauj Ruam 1. Qhib koj lub khoos phis tawj thiab qhib daim ntawv Excel tshiab lossis tam sim no
Kauj Ruam 2. Hauv txhua lub cell, rau qhov piv txwv no peb yuav siv A2, ntaus koj hnub tim
Ex 1/1/2006 NPE
Kauj Ruam 3. Hauv ib lub xovtooj sib txawv, rau qhov piv txwv no peb siv B2, ntaus tus lej ntawm lub hlis ntawm tes A2 yuav tsum tau nce ntxiv los ntawm
Ex 5
Kauj Ruam 4. Hauv cell kawg sau hom mis:
= DATE (YEAR (A2), HLI (A2)+ B2, MIN (HNUB (A2), HNUB (HNUB (YEAR (A2), HLI (A2)+ B2+1, 0)))) hloov dab tsi hauv qhov ua siab tawv nrog cov cell tsim nyog rau koj daim ntawv nthuav tawm.
Kauj Ruam 5. Koj yuav pom tias lub xov tooj ntawm tes tam sim no tau suav qhov xav tau
Kauj Ruam 6. Lwm qhov kev xaiv yog siv = EDATE (pib_date, hli)
Qhov no yog txoj hauv kev yooj yim dua tab sis tsuas yog siv tau yog tias Kev Tshawb Fawb ToolPak tau ntxiv rau hauv.