Siv NETWORKDAYS muaj nuj nqi hauv Google Cov Ntawv los suav cov hnub ua haujlwm tag nrho ntawm cov hnub pib thiab hnub kawg. Nrog rau txoj haujlwm no, cov hnub so (Saturday thiab Sunday) raug tshem tawm ntawm tag nrho. Cov hnub tshwj xeeb, xws li cov hnub caiv raws cai, tuaj yeem raug tshem tawm, ib yam nkaus.
NETWORKDAYS Function Syntax and Arguments
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.
Cov ntsiab lus rau NETWORKDAYS muaj nuj nqi yog NETWORKDAYS(start_date, end_date, [hnub so]).
Cov lus sib cav yog:
- Start_date - hnub pib ntawm lub sijhawm xaiv (yuav tsum tau)
- End_date - hnub kawg ntawm lub sijhawm xaiv (yuav tsum tau)
- Holidays - ib lossis ntau hnub ntxiv uas tsis suav nrog tag nrho cov hnub ua haujlwm (yeem)
Siv cov hnub tseem ceeb, cov lej xov tooj, lossis cov xov tooj ntawm tes siv rau qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv ua haujlwm rau ob hnub sib cav.
Hnub so tuaj yeem yog hnub cov nqi nkag ncaj qha rau hauv cov qauv lossis cov lus qhia ntawm tes rau qhov chaw ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm.
Vim NETWORKDAYS tsis tuaj yeem hloov cov ntaub ntawv mus rau hnub tim, cov hnub tseem ceeb nkag ncaj qha rau hauv txoj haujlwm rau tag nrho peb qhov kev sib cav yuav tsum tau nkag mus siv DATE lossis DATEVALUE kev ua haujlwm kom tsis txhob suav qhov yuam kev.
-
Xaiv lub xovtooj uas koj xav kom tshwm sim.
Image - Nkag mus rau cov qauv thiab cov ntsuas tsim nyog. Piv txwv li, txhawm rau xam cov hnub ua haujlwm ntawm hnub tim hauv hlwb A3 thiab A4, sau=NETWORKDAYS(A3, A4). Qhov no qhia Sheets kom suav cov hnub ua haujlwm ntawm 7/11/2016 thiab 11/4/2016.
-
Xaiv cov hnub ua haujlwm yam tsis siv cov ntaub ntawv xovtooj, nkag rau=NETWORKDAYS(hnub, hnub tim) - piv txwv li,=NETWORKDAYS(7/11/16, 11/4/2016).
Tus VALUE! Tus nqi yuam kev raug xa rov qab yog tias muaj kev sib cav muaj hnub tsis raug.
lej tom qab muaj nuj nqi
Google Sheets ua cov txheej txheem suav hauv ob kauj ruam. Ua ntej, nws ntsuas qhov ncaj ncaj ntawm cov hnub ua haujlwm ntawm ob hnub tau teev tseg.
Tom qab ntawd, nws tshem tawm txhua hnub uas tau teev tseg hauv hnub so kev sib cav, yog hnub tshwm sim rau hnub ua haujlwm. Piv txwv li, yog tias lub sijhawm muaj ob hnub so (piv txwv li, Memorial Day thiab Independence Day, hauv Tebchaws Meskas), thiab cov hnub ntawd ob qho tib si tshwm sim rau hnub ua haujlwm, ces cov thawj suav ntawm hnub raug txo los ntawm ob, thiab cov lus teb tau tshwm sim. nyob rau hauv daim ntawv nthuav qhia.
