Izinsuku zokubala Phakathi kweeDatha kwiiSpredishithi zeGoogle

I-Tutorial: Indlela yokusebenzisa umsebenzi we-NETWORKDAYS

AmaSpredishithi e-Google anemisebenzi yamaphepha ekhoyo ekhoyo, kwaye umsebenzi ngamnye kwiqela wenza umsebenzi ohlukile.

Umsebenzi we-NETWORKDAYS ungasetyenziselwa ukubala inani lebhizinisi elipheleleyo okanye iintsuku zokusebenza phakathi kwexesha eliqaliweyo lokuqalisa nokuphela. Ngalo msebenzi, iintsuku zangeveki (ngoMgqibelo nangeCawa) zisuswe ngokuzenzekelayo kwixabiso. Iintsuku ezithile, njengeeholide ezisemthethweni, zingakhishwa kwakhona.

Sebenzisa i-NETWORKDAYS xa uceba okanye usibhale iziphakamiso zokubaluleka kwexesha leprojekthi okanye ukubuyela emva-ukubala inani lexesha elichithwe ekugqityiweyo.

01 ka 03

I-NETWORKDAYS Umsebenzi we-Syntax kunye neMigomo

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-NETWORKDAYS ngu:

= I-NETWORKDAYS (qalisa_kudala, ukuphela kwexesha, iiholide)

Iingxoxo zilandelayo:

• qala_date - (efunekayo) umhla wokuqala wexesha elikhethiweyo
• i-end_date - (efunekayo) umhla wokuphela kwexesha elikhethiweyo

Sebenzisa ixabiso lexesha, iinombolo zeenombolo , okanye iselferensi yesalathisi kwindawo yolu datha kwiphepha lokusebenzela ezimbini zombambano.

• iiholide - (okukhethwa kukho) enye okanye eminye imihla eyongezelelweyo engabandakanyiyo kwinani leentsuku zokusebenza

Imihla yeeholide ingaba yimihla yamanani angeniswe ngqo kwifomula okanye iinkcukacha zeseli kwindawo yokusebenza kwiphepha lokusebenzela.

Amanqaku: Njengoko i-NETWORKDAYS ayiguquli ngokuzenzekelayo idatha kwiifomathi zosuku, amanani omhla angeniswe ngqo kwimisebenzi yazo zonke iziphakamiso kufuneka zifakwe ku- DATE okanye ngomhla we-DATEVALUE ukukhusela iimpazamo zokubala, njengoko kuboniswe kumqolo 8 womfanekiso ohamba kunye nale nqaku .

#VALUE! Ixabiso lephutha libuyiselwa ukuba nayiphi na ingxabano iqulethe usuku olungavumelekanga.

02 ka 03

I-Tutorial: Bala inani leeNtsuku zokusebenza phakathi kwamaxesha amabini

Le khokelo ibonisa indlela ezahlukileyo ngayo umsebenzi we-NETWORKDAYS ukubala inani leentsuku zomsebenzi phakathi kukaJulayi 11, 2016, kunye noNovemba 4, 2016, kwi-Google AmaSpredishithi.

Sebenzisa umfanekiso ohamba kunye nale nqaku ukulandela kunye nale khokelo.

Ngokomzekelo, iiholide ezimbini (Septemba 5 no-Oktobha 10) zenzeka ngeli xesha kwaye zithathwe kwi-total.

Umfanekiso ubonisa ukuba iziphakamiso zomsebenzi zingangeniswa ngqo kumsebenzi njengemilinganiselo yosuku okanye njengeenombolo ze-serial okanye njengeenkcukacha zeseli kwindawo yendawo kwiphepha lokusebenzela.

Amanyathelo okufaka umsebenzi we-NETWORKDAYS

AmaSpredishithi eGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwiseli C5 ukuze wenze iseli esebenzayo .
2. Thayipha uphawu olulinganayo ( = ) olulandelwe igama lomsebenzi weevenkile zentsuku .
3. Njengoko uthayipha, ibhokisi ye -auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta N.
4. Xa igama leewebhsayithi libonakala kwibhokisi, nqakraza kwigama kunye ne-pointer ye mouse ukuze ufake igama lomsebenzi kunye nabazali abavulekileyo okanye i-bracket ejikelezayo " ( " kwiSeli C5.
5. Cofa kwiseli A3 kwiphepha lokusebenzela ukuze ufake le ferensi yeseli njengengxoxo ye- start_date .
6. Emva kwereferensi yeseli, thayipha i-comma ukuba uhlule phakathi kweengxoxo.
7. Cofa kwiseli A4 ukungena kule ferensi yeseli njengengxoxo yokugqibela_date .
8. Emva kwereferensi yeseli, thayipha i-comma yesibini.
9. Phakamisa iiseli ze- A5 kunye ne-A6 kwiphepha lokusebenzela ukuze ufake olu luhlu lweenkcukacha zeefesiti njenge- holiday argument.
10. Cinezela ukhiye wokungena kwibhodibhodi ukongeza ababelethi bokuvala " ) " kwaye uzalise umsebenzi.

Inani leentsuku zokusebenza-83-livela kwiseli C5 kwiphepha lokusebenzela.

Xa ucofa kwi-cell C5, umsebenzi opheleleyo
= I-NETWORKDAYS (A3, A4, A5: A6) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

03 ka 03

I-Math Behind Umsebenzi

Iifayile zeGoogle zifika njani kwimpendulo ye-83 kumqolo wesi-5 ngu:

• Inani leentsuku zeveki phakathi kukaJulayi 11 noNovemba 4, 2016, lilingana nama-85 (iiveki ezili-17 x 5 iintsuku ngeveki). Yisiphumo semigca yesithathu kunye ne-4 apho ingxabano yeeholide ingafaki.
• Kule totali, iimihla ezimbini zeeholide ezichaziweyo (Septemba 5 no-Oktobha 10) zisuswe ukushiya umphumo weentsuku eziyi-83 zokusebenza.

Qaphela: Ukuba iintsuku zeveki zingeye ngoMgqibelo nangeCawa okanye enye imini ngeveki, sebenzisa umsebenzi we-NETWORKDAYS.INTL.