Hauv qhov kev qhia no, koj yuav kawm paub yuav ua li cas kom tau txais hnub ntawm lub lim tiam los ntawm hnub hauv Excel thiab suav cov hnub ua haujlwm / hnub ua haujlwm li cas ntawm ob hnub.
DAY function
- muaj nuj nqi HNUB (WEEKDAY) hauv Excel rov qab tus lej ntawm 1 (Sunday) thiab 7 (Saturday) sawv cev rau tus lej ntawm hnub ntawm lub lim tiam. Nws zoo nkaus li tias Lub Kaum Ob Hlis 16, 2013 hauv cov qauv hauv qab no poob rau hnub Monday.
=WEEKDAY(A1)=ДЕНЬНЕД(A1) - Koj tuaj yeem siv cov haujlwm los tso saib hnub ntawm lub lim tiam TEXT (TSHIAB).
=TEXT(A1,"dddd")=ТЕКСТ(A1;"дддд")
- Tsim ib hom kev cai hnub tim (ddd) los tso saib lub npe hnub ntawm lub lim tiam.
Muaj nuj nqi CLEAR
- muaj nuj nqi PURE cov neeg ua haujlwm (NETWORKDAYS) xa rov qab cov hnub ua haujlwm (tsis suav hnub so) ntawm ob hnub.
=NETWORKDAYS(A1,B1)=ЧИСТРАБДНИ(A1;B1) - Yog hais tias koj qhia ib daim ntawv teev hnub so, ces muaj nuj nqi PURE cov neeg ua haujlwm (NETWORKDAYS) yuav rov qab cov hnub ua haujlwm (tsis suav hnub so thiab hnub so) ntawm ob hnub.
=NETWORKDAYS(A1,B1,E1:E2)=ЧИСТРАБДНИ(A1;B1;E1:E2)Daim ntawv qhia hnub hauv qab no yuav pab koj nkag siab zoo txog txoj haujlwm PURE cov neeg ua haujlwm (NWS NETWORK).
- Excel khw muag khoom hnub tim raws li tus lej thiab suav cov hnub txij li Lub Ib Hlis 0, 1900. Tsis txhob hloov ntau lub hlwb rau hauv cov qauv, hloov cov lej tsis tu ncua uas sawv cev rau cov hnub ntawd. Ua li no, xaiv 1 :e2 hauv cov qauv hauv qab no thiab nyem F9.
=NETWORKDAYS(A1,B1,{41633;41634})=ЧИСТРАБДНИ(A1;B1;{41633;41634})
KEV UA HAUJ LWM
- muaj nuj nqi UA HAUJ LWM (WORKDAY) yuav luag rov ua haujlwm PURE cov neeg ua haujlwm (NWS NETWORK). Nws xa rov qab hnub ua ntej lossis tom qab tus lej teev hnub ua haujlwm (hnub so tsis suav nrog).
=WORKDAY(A1,B1)=РАБДЕНЬ(A1;B1)
Nco ntsoov: muaj nuj nqi UA HAUJ LWM (WORKDAY) xa rov qab tus lej xov tooj ntawm hnub. Siv lub hnub hom rau ib lub xov tooj los tso saib nws.
Daim ntawv qhia hnub hauv qab no yuav pab koj nkag siab zoo txog txoj haujlwm UA HAUJ LWM (HMOOB).
Ntxiv dua thiab, yog tias koj hloov cov npe hnub so, cov haujlwm UA HAUJ LWM (WORKDAY) yuav rov qab hnub ua ntej lossis tom qab cov hnub ua haujlwm tau teev tseg (tsis suav hnub so thiab hnub so).