Koj tuaj yeem suav hnub nyoog ntawm Excel rau ntau daim ntawv thov los ntawm kev sib txuas ua haujlwm yam tsis muaj ntaub ntawv thiab hnub tim rau cov xov tooj. Microsoft Excel khaws cov hnub tim hauv tsev raws li tus lej lej, uas yog tus naj npawb ntawm cov hnub ib hnub yog los ntawm Lub Ib Hlis 1, 1900. DATEDIF muaj nuj nqi yuav sib piv qhov sib txawv ntawm ob hnub tshwj xeeb, uas koj tuaj yeem siv los txiav txim siab ib tus neeg lub hnub nyoog.
Cov kauj ruam
Kauj Ruam 1. Tsim kab "Npe"
Nws tsis tas yuav muaj daim ntawv lo, tab sis qhov no yog kab ntawv uas yuav txheeb xyuas txhua tus neeg uas koj tab tom suav hnub yug rau.
Kauj Ruam 2. Tsim kab "Hnub Yug"
Kab ntawv no yuav suav nrog txhua lub hnub yug ua kab sib cais.
Koj tsis tas yuav siv qhov no rau hnub yug tshwj xeeb. Koj tuaj yeem siv txhua qhov pib, xws li "Hnub Xa Khoom," "Hnub Yuav Khoom," thiab lwm yam
Kauj Ruam 3. Nkag mus rau hnub yug siv hom ntawv sib xws
Nco ntsoov txhua hnub yug tau siv tib hom ntawv. Yog tias koj nyob hauv Asmeskas, siv MM/DD/YYYY. Yog tias koj nyob lwm qhov, siv DD/MM/YYYY. Excel yuav tsum tau txiav txim siab tias koj tab tom nkag rau hnub, thiab yuav ua cov ntaub ntawv raws li.
Yog tias cov ntaub ntawv tau pib ua qauv zoo li lwm yam, hais txog lub xov tooj thiab nyem rau ntawm cov ntawv qhia zaub mov nco hauv ntu "Numbers" ntawm Tsev Tsev tab. Xaiv "Hnub Hnub luv" los ntawm cov npe xaiv
Kauj Ruam 4. Tsim kab "Hnub Nyoog"
Kab ntawv no yuav tso saib hnub nyoog rau txhua qhov nkag teb chaws tom qab koj nkag mus rau tus lej.
Kauj Ruam 5. Xaiv thawj lub cell khoob hauv kab ntawv "Hnub Nyoog"
Nov yog qhov uas koj yuav nkag mus rau tus lej xam hnub yug.
Kauj Ruam 6. Nkag mus rau tus lej xam lub hnub nyoog hauv xyoo
Ntaus cov qauv hauv qab no, uas xav tias thawj hnub yug tau teev tseg hauv cell B2:
- = DATEDIF (B2, TODAY (), "Y")
- = DATEDIF () yog lub luag haujlwm uas suav qhov sib txawv ntawm ob hnub. (B2, TODAY (), "Y") qhia DATEDIF los xam qhov sib txawv ntawm hnub tim hauv cell B2 (thawj hnub yug tau teev tseg) thiab hnub tam sim no (TODAY ()). Nws tawm qhov kev suav hauv xyoo ("Y"). Yog tias koj xav pom hnub nyoog nyob rau hnub lossis hli, siv "D" lossis "M" hloov.
Kauj Ruam 7. Nyem thiab rub lub xwmfab hauv qab-sab xis ntawm lub xovtooj
Qhov no yuav siv cov qauv ib yam rau txhua kab, kho nws kom raug thiaj li tau suav hnub yug kom raug.
Kauj Ruam 8. Teeb meem cov mis uas tsis ua haujlwm
Yog tias cov mis tau nthuav tawm qee yam zoo li #VALUE! lossis #NAME ?, tom qab ntawv yuav muaj qhov yuam kev nyob qhov twg hauv cov mis. Xyuas kom tseeb tias cov syntax yog qhov raug, thiab koj tab tom taw tes rau cov hlwb raug hauv daim ntawv nthuav qhia. Nco ntsoov tias DATEDIF () mis tsis ua haujlwm rau hnub ua ntej 1900-01-01.
Kauj Ruam 9. Hloov kho cov mis kom xam hnub nyoog pes tsawg xyoo, hli, thiab hnub
Yog tias koj xav tau lub hnub nyoog ntxaws ntxaws, koj tuaj yeem muaj Excel suav hnub nyoog pes tsawg xyoo, hli, thiab hnub. Qhov no siv tib cov qauv yooj yim raws li tau piav qhia saum toj no, tab sis nrog ntau qhov kev sib cav kom koj tau txais lub hnub nyoog tseeb:
