Yuav Paub
- Syntax for function: DAY(serial_number).
- Tau hnub nyob rau hauv daim ntawv nthuav qhia > xaiv cell > xaiv Formulas > Hnub & sijhawm > DAY > Serial_number> xaiv cell.
- Yog tsis ua hauj lwm, xaiv hnub tim kab > right-click thiab xaiv Format Cells > Number tab > Number > OK.
Kab lus no piav qhia yuav ua li cas siv DAY function hauv Microsoft Excel kom rov qab hnub raws li tus lej xov tooj siv tus lej ntawm 1 thiab 31.
Yuav ua li cas Siv Hnub Nyoog hauv Excel
Tus syntax rau hnub ua haujlwm yog DAY(serial_number).
Qhov kev sib cav nkaus xwb rau HNUB muaj nuj nqi yog serial_number, uas yuav tsum tau ua. Daim teb no yog hais txog hnub uas koj tab tom nrhiav.
Hnub yog cov lej cim hauv Excel lub hauv paus system. Pib txij Lub Ib Hlis 1, 1900 (uas yog tus naj npawb 1), txhua tus lej raug muab tso rau hauv tus lej nce. Piv txwv li, Lub Ib Hlis 1, 2008 yog tus lej 39448 vim nws yog 39447 hnub tom qab Lub Ib Hlis 1, 1900.
Excel siv tus lej lej nkag los txiav txim siab hnub twg ntawm lub hli hnub poob rau. Hnub rov qab los ua tus lej suav txij li 1 txog 31.
-
Sau hnub tim hauv Excel spreadsheet siv DATE muaj nuj nqi. Koj tuaj yeem siv cov hnub uas tshwm sim los ntawm lwm cov qauv lossis cov haujlwm.
Yog cov hnub tau sau ua ntawv, HNUB ua haujlwm yuav tsis ua haujlwm raws li nws yuav tsum tau ua.
Image -
Xaiv lub xovtooj uas koj xav tau hnub ntawm hnub tshwm sim.
-
Xaiv Formula. Hauv Excel Online, xaiv qhov Insert Function khawm ntawm ib sab ntawm tus qauv bar kom qhib lub Insert Function dialog box.
Image -
Xaiv Hnub & Lub Sijhawm txhawm rau qhib Daim Ntawv Teev Npe Ua Haujlwm. Hauv Excel Online, xaiv Hnub & Lub Sijhawmhauv Xaiv ib pawg npe.
Image -
Xaiv DAY nyob rau hauv daim ntawv los nqa lub luag haujlwm lub dialog box.
Image -
Ua kom paub tseeb tias qhov Serial_number teb raug xaiv thiab tom qab ntawd xaiv lub xov tooj ntawm tes uas muaj hnub koj xav siv.
Image - Xaiv OK txhawm rau siv txoj haujlwm thiab saib tus lej sawv cev hnub ntawm hnub.
Hnub Ua Haujlwm Tsis Ua Haujlwm
Yog tias koj cov txiaj ntsig tsis tshwm sim li cov lej tab sis yog hnub, nws yuav yog qhov teeb meem yooj yim formatting. Teeb meem tuaj yeem tshwm sim yog tias cov lej raug formatted ua ntawv tsis yog hnub. Tshawb xyuas cov hom ntawv rau cov hlwb uas muaj cov lej xov tooj ntawm DAY function syntax (thiab tom qab ntawd hloov hom ntawv, yog tias tsim nyog) yog txoj hauv kev zoo tshaj los daws qhov yuam kev lossis tsis raug.
- Xaiv kab uas muaj cov hnub.
-
Right-click nyob qhov twg ntawm cov hlwb uas tau xaiv thiab xaiv Format Cells.
Image -
Nco ntsoov xaiv Number tab thiab xaiv Number hauv qeb npe.
Image - Xaiv OK txhawm rau siv cov kev hloov pauv thiab kaw qhov kev sib tham. Koj cov txiaj ntsig yuav tshwm sim ua tus lej tsis yog hnub.
Thaum siv Hnub Ua Haujlwm hauv Excel
Hnub muaj nuj nqi tseem ceeb rau kev txheeb xyuas nyiaj txiag, feem ntau hauv kev lag luam. Piv txwv li, lub koom haum muag khoom yuav xav txiav txim seb hnub twg ntawm lub hli muaj cov neeg siv khoom ntau tshaj plaws lossis thaum cov khoom xa tuaj ntau tshaj plaws.
Koj tuaj yeem rho tawm tus nqi siv HNUB ua haujlwm hauv cov qauv loj dua. Piv txwv li, hauv daim ntawv ua haujlwm no, DAY function pab txiav txim seb muaj pes tsawg hnub nyob rau hauv lub hlis teev.
Tus qauv nkag hauv cell G3 yog
=DAY(EOMONTH(F3, 0))
Hnub ua haujlwm muab hnub tivthaiv thiab EOMONTH (kawg lub hli) muab rau koj hnub kawg ntawm lub hli rau hnub ntawd. Lub syntax rau EOMONTH yog EOMONTH(start_date, months) Yog li hnub pib sib cav yog hnub nkag thiab tus naj npawb ntawm lub hlis yog 0, ua rau cov npe qhia cov hnub hauv lub hlis. nthuav tawm.
Ceev faj kom tsis txhob cuam tshuam HNUB ua haujlwm nrog DAYS muaj nuj nqi. DAYS muaj nuj nqi, uas siv cov syntax DAYS(end_date, start_date) rov qab cov hnub ntawm hnub pib thiab hnub kawg.
