Nrhiav hnub kawg rau qhov project nrog cov hnub ua haujlwm tom qab hnub pib.
Nrhiav hnub pib rau qhov project nrog cov hnub ua haujlwm ua ntej hnub kawg.
Nrhiav hnub kawg rau daim ntawv them nqi.
Nrhiav hnub xa khoom xav tau rau cov khoom lossis cov khoom siv.
WORKDAY Function's Syntax (Layout)
A muaj nuj nqi syntax yog hais txog kev teeb tsa ntawm txoj haujlwm thiab suav nrog lub luag haujlwm lub npe, cov hlua khi, thiab cov lus sib cav.
Image
Cov lus sib dhos rau txoj haujlwm ua haujlwm yog:
=WORKDAY(Start_date, Hnub, Hnub So )
Start_date (yuav tsum tau) yog hnub pib ntawm lub sijhawm xaiv. Hnub pib qhov tseeb tuaj yeem nkag mus rau qhov kev sib cav no lossis kev siv xovtooj ntawm qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv ua haujlwm tuaj yeem nkag mus xwb.
Hnub (yuav tsum tau) qhia qhov ntev ntawm qhov project. Qhov no yog tus lej qhia cov hnub ua haujlwm uas yuav ua rau ntawm qhov project. Rau qhov kev sib cav no, nkag mus rau cov hnub ua haujlwm lossis lub xov tooj ntawm tes siv rau qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv ua haujlwm.
txhawm rau nrhiav hnub uas tshwm sim tom qab kev sib cav Start_date, siv tus lej zoo rau Hnub. Txhawm rau nrhiav hnub uas tshwm sim ua ntej qhov kev sib cav Start_date siv tus lej tsis zoo rau Hnub.
Hlidays (optional) qhia ib lossis ntau hnub ntxiv uas tsis suav ua ib feem ntawm tag nrho cov hnub ua haujlwm. Siv cov ntawv xovtooj xa mus rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm rau qhov kev sib cav no.
Yuav ua li cas Siv Lub Sijhawm Ua Haujlwm los nrhiav Hnub Kawg-lossis Hnub Kawg
Qhov kev qhia no siv WORKDAY muaj nuj nqi txhawm rau nrhiav hnub kawg rau qhov project uas pib lub Xya Hli 9, 2012, thiab ua tiav 82 hnub tom qab. Ob hnub so (Lub Cuaj Hlis 3 thiab Lub Kaum Hli 8) uas tshwm sim nyob rau lub sijhawm no tsis raug suav ua ib feem ntawm 82 hnub.
Image
Txhawm rau zam cov teeb meem kev suav uas tshwm sim yog cov hnub tsis raug sau ua ntawv, siv DATE muaj nuj nqi txhawm rau nkag mus rau cov hnub hauv txoj haujlwm. Saib cov nqi yuam kev ntawm qhov kawg ntawm qhov kev qhia no kom paub ntau ntxiv.
Txhawm rau ua raws li cov lus qhia no, nkag mus rau cov ntaub ntawv hauv qab no rau hauv lub hlwb qhia:
D1: Pib Hnub:
D2: Hnub Nyoog:
D3: Hnub so 1:
D4: Hnub so 2:
D5: Hnub Kawg:
E1:=DATE(2012, 7, 9)
E2: 82
E3:=DATE(2012, 9, 3)
E4:=DATE (2012, 10, 8)
Yog tias cov hnub hauv hlwb E1, E3, thiab E4 tsis tshwm sim raws li qhia hauv daim duab hauv qab no, tsim cov hlwb los tso saib cov ntaub ntawv siv hom hnub luv.
Create the WORKDAY Function
Tsim kom muaj haujlwm ua haujlwm:
Xaiv cell E5 los ua kom nws lub cev muaj zog. Nov yog qhov kev tshwm sim ntawm WORKDAY muaj nuj nqi yuav tshwm sim.
Image
Mus rau Formula tab thiab xaiv Hnub & Sijhawm > Ua Haujlwm los tso saib Function Arguments dialog box.
Image
Thaum siv cov qauv WORKDAY hauv Google Sheets, mus rau Insert > Function > All > WORKDAY. Los yog, nkag mus =WORKDAY(hauv cell E5.
Muab tus cursor rau hauv Start_date lub thawv ntawv, tom qab ntawd xaiv lub xovtooj E1 hauv daim ntawv ua haujlwm txhawm rau nkag mus rau lub xovtooj ntawm no hauv lub dialog box.
Image
In Google Sheets, nkag mus E1 tom qab thawj kab lus hauv xov tooj E5.
Muab tus cursor rau hauv Hnub lub thawv ntawv, tom qab ntawd xaiv cell E2 nkag mus rau qhov siv ntawm tes.
Image
Hauv Google Sheets, nkag mus rau lub cim thiab ntaus E2 kom cov mis zoo li no:
=WORKDAY(E1, E2)
Muab tus cursor rau hauv Holidays lub thawv ntawv, tom qab ntawd luag los xaiv cov hlwb E3 thiab E4siv cov ntaub ntawv xovtooj.
Image
Nyob hauv Google Sheets, xaus cov qauv nrog tus lej cim, tom qab ntawd nkag mus E3:E4. Cov mis zoo li no:
=WORKDAY(E1, E2, E3:E4)
Xaiv OK hauv lub dialog box kom ua tiav txoj haujlwm. Ntawm Mac, xaiv Done. Hauv Google Sheets, nias Enter.
Hnub tim 11/2/2012, hnub kawg rau qhov project, tshwm hauv cell E5 ntawm daim ntawv ua haujlwm. Thaum koj xaiv lub xov tooj ntawm tes E5, qhov ua tiav tiav tshwm nyob rau hauv daim ntawv qhia bar saum daim ntawv ua haujlwm.
Tswv daws teeb meem ua haujlwm hnub ua haujlwm yuam kev
Yog tias cov ntaub ntawv rau ntau qhov kev sib cav ntawm qhov kev ua haujlwm no tsis raug nkag mus, qhov kev ua yuam kev tshwm sim hauv lub xovtooj ntawm qhov chaw ua haujlwm WORKDAY.
Image
Koj yuav pom ib qho ntawm cov yuam kev no:
VALUE! tshwm hauv cov lus teb yog tias ib qho ntawm WORKDAY sib cav tsis yog hnub siv tau (yog tias hnub tim tau sau ua ntawv, piv txwv).
Yog cov hnub sib cav tsis tau nkag los ua tus lej (xws li 82.75 hnub), tus lej raug txiav, tsis yog sib npaug lossis nqis, mus rau feem ntau ntawm tus lej (piv txwv li, 82 hnub).
Ua ntej koj yuav Chromebook tshiab, tshawb xyuas qhov pib hloov tshiab tas sij hawm (AUE), lossis hnub kawg ntawm lub neej. Nov yog yuav ua li cas tom qab koj Chromebook qhov kawg software hloov tshiab
