Nyeem: Yuav siv cov haujlwm NETWORKDAYS li cas
Cov ntawv Google muaj ntau lub hnub tso tawm, thiab txhua txoj haujlwm hauv pawg tsis muaj haujlwm ntau.
NETWORKDAYS muaj peev xwm siv tau los laij cov xov tooj ntawm cov lag luam lossis hnub ua hauj lwm nruab nrab ntawm pib thiab xaus lub sijhawm. Nrog rau kev ua haujlwm no, hnub vas xaum (Hnub vas Xuv thiab Hnub Sunday) yuav raug tshem tawm ntawm tag nrho. Cov hnub tshwj xeeb, xws li kev cai hnub so, raug rho tawm thiab.
Siv NETWORKDAYS thaum npaj los sau cov ntawv thov los txiav txim seb lub sijhawm twg rau qhov kev tsim ua ntej lossis rov qab-xam cov nqi ntawm cov sijhawm siv rau ib qho tiav.
01 ntawm 03
NETWORKDAYS Muaj nuj nqi Syntax thiab sib ceg
Ib qho kev ua haujlwm syntax hais txog qhov teeb tsa ntawm txoj haujlwm thiab suav nrog txoj haujlwm, lub npe, thiab sib cam .
Lub syntax rau NETWORKDAYS muaj nuj nqi yog:
= NETWORKDAYS (pib_date, end_date, cov hnub caiv)Cov lus sib cav yog:
- pib_date - (yuav tsum tau) hnub pib lub sijhawm xaiv
- end_date - (yuav tsum tau) hnub kawg ntawm lub sijhawm xaiv
Siv cov hnub tseem ceeb, tus lej zauv , los yog lub xovtooj ntawm kev xa mus rau qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv rau ob nqe lus.
- hnub so - (yeem) ib lossis ntau hnub ntxiv uas tsis suav nrog tag nrho cov hnub ua haujlwm
Cov hnub so txaus siab tuaj yeem sau hnub uas tau nkag mus rau hauv cov qauv mis los yog cov xov tooj ntawm tes rau qhov chaw nyob ntawm daim ntawv ua haujlwm.
Lus Cim: Vim tias NETWORKDAYS tsis tuaj yeem hloov hloov cov ntaub ntawv rau hnub tim, cov hnub ntaus nqi nkag ncaj qha mus rau txhua qhov kev sib tham rau peb txhua hnub yuav tsum tau nkag mus siv DATE lossis DATEVALUE kev ua haujlwm kom tsis txhob muab xam cov kev ua yuam kev, raws li muaj nyob hauv kab 8 ntawm daim duab uas nrog tsab xov xwm no .
Lub #VALUE! tus nqi yuam kev rov qab yog tias muaj kev sib cav muaj hnub tsis muaj tseeb.
02 ntawm 03
Nyeem: Suav Cov Hnub Ua Haujlwm Hnub Ntawm Ob Hnub
Cov ntawv nyeem no qhia txog tias ntau qhov kev hloov ntawm NETWORKDAYS muaj nuj nqi siv los xam cov hnub ua hauj lwm thaum lub Xya Hli 11, 2016, thiab Kaum Ib Hlis 4, 2016, hauv Google Phab Ntawv.
Siv daim duab nrog accompanies qhov tsab xov xwm no ua raws nrog kev nyeem ntawv no.
Hauv qhov ua piv txwv, ob hnub so (Lub Cuaj Hlis 5 thiab Lub 10 Hli 10) tshwm sim rau lub sijhawm no thiab txiav tawm ntawm tag nrho.
Daim duab qhia tau hais tias qhov kev ua haujlwm qhov kev sib txuas lus tuaj yeem nkag ncaj qha mus rau qhov kev ua haujlwm raws hnub qhov tseem ceeb lossis raws li cov zauv los yog raws li cov xov tooj xa mus rau qhov chaw nyob ntawm daim ntawv ua haujlwm.
Cov kauj ruam mus nkag rau NETWORKDAYS Function
Google los xij tsis siv cov thawv ntawv sib txuas lus los nkag rau cov lus sib cav raws li muaj nyob rau hauv Excel. Xwb, nws muaj lub thawv pib-hais tias pops tuaj li lub npe ntawm qhov ua haujlwm yog ntaus rau hauv ib lub xov tooj ntawm tes.
- Nias ntawm tes C5 los ua nws lub xovtooj ntawm tes .
- Ntaus qhov cim sib npaug ( = ) raws li lub npe ntawm cov haujlwm networkdays .
- Raws li koj ntaus ntawv, nws pib-qhia lub thawv tshwm nrog cov npe thiab syntax ntawm cov haujlwm uas pib ntawm tsab ntawv N.
- Thaum lub npe network hnub pom hauv lub thawv, nias rau lub npe nrog tus pointer pointer nkag rau lub npe muaj nuj nqi thiab qhib parenthesis los yog kev hloov bracket " ( " rau hauv C5.
- Nias ntawm Cell A3 hauv daim ntawv khij nyiab los nkag rau lub xovtooj ntawm tes no yog qhov pib kev sib tw pib_date .
- Tom qab siv xov tooj ntawm tes, ntaus ib qho kev poob vias ua ib qho kev cais ntawm cov nqe lus.
- Nyem ntawm xovtooj ntawm A4 kom nkag mus rau qhov siv xovtooj ntawm tes no yog qhov kev sib tw kawg.
- Tom qab siv xov tooj ntawm tes, ntaus ib qho thib ob.
- Highlight hlwb A5 thiab A6 nyob rau hauv daim ntawv khij nyiab los nkag rau ntau yam ntawm cov xov tooj ntawm tes raws li kev sib tw nyiaj so koobtsheej .
- Nias tus yuam sij nkag rau ntawm cov keyboard kom ntxiv rau pawg niam txiv kaw " ) " thiab kom tiav qhov haujlwm.
Tus naj npawb ntawm cov hnub ua hauj lwm-83-tshwm nyob hauv Cell C5 ntawm daim ntawv ua haujlwm.
Thaum koj nias ntawm tes C5, ua tiav tiav
= NETWORKDAYS (A3, A4, A5: A6) tshwm nyob rau hauv qhov formula formula saum toj daim ntawv ua haujlwm.
03 ntawm 03
Cov Lej Qab Ua Haujlwm
Yuav ua li cas Google cov ntawv txheeb txog tuaj ntawm lo lus teb ntawm 83 hauv kab 5 yog:
- Tag nrho cov hnub ua haujlwm ntawm Lub Xya Hli 11 thiab Lub Kaum Ib Hlis 4, 2016, sib npaug 85 (17 asthiv x 5 hnub hauv ib lub lis piam). Nws yog qhov tshwm sim rau kab 3 thiab 4 qhov kev sib cav hnub caiv rho tawm.
- Los ntawm tag nrho cov no, ob hnub cov hnub so (Cuaj Hlis 5 thiab Lub 10 Hli 10) raug muab rho tawm vim tias 83 hnub ua haujlwm.
Lus Cim: Yog hnub vas xaum vas thiv tsis yog Hnub Saturday thiab Hnub Ib lossis ib hnub ib lim piam twg, siv cov nuj nqi NETWORKDAYS.INTL.