Izinsuku zokubala phakathi kwezinsuku kuma-Google AmaSpredishithi

Isifundo: Indlela yokusebenzisa umsebenzi we-NETWORKDAYS

AmaSpredishithi e-Google anemisebenzi eminingi yamanje etholakalayo, futhi umsebenzi ngamunye eqenjini wenza umsebenzi ohlukile.

Umsebenzi we-NETWORKDAYS ungasetshenziswa ukubala inombolo yebhizinisi lonke noma izinsuku zokusebenza phakathi kwezinsuku eziqalile zokuqala nezinsuku zokuphela. Ngalolu msebenzi, izinsuku zezimpelasonto (ngoMgqibelo nangeSonto) zisuswe ngokuzenzakalelayo kusukela kuphelele. Izinsuku ezithile, njengamaholidi asemthethweni, zingashiywa futhi.

Sebenzisa i-NETWORKDAYS uma uhlela noma ubeka iziphakamiso zokunquma isikhathi sesikhathi seprojekthi ezayo noma ukubuyela emuva-ukubala inani lesikhathi esichithwe ekugcineni.

01 ka-03

I-NETWORKDAYS Umsebenzi we-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-NETWORKDAYS yile:

= I-NETWORKDAYS (qala_kudala, ukuphela_kudlula, amaholidi)

Iziphakamiso zithi:

• qala_date - (edingekayo) usuku lokuqala kwesikhathi esikhethiwe
• ekugcineni_kudlule - (okudingekayo) usuku lokuphela kwesikhathi esikhethiwe

Sebenzisa amanani wedethi, izinombolo ze-serial , noma ireferensi yeseli endaweni yile datha kushidi lokusebenzela lazo zombili izimpikiswano.

• amaholidi - (okukhethwa kukho) izinsuku ezilodwa noma ngaphezulu ezengeziwe ezingabalwa kusukela enani lezinsuku zokusebenza zokusebenza

Izinsuku zeholide zingaba ngamanani wosuku afakwe ngqo kwifomula noma izinkomba zesitokisi endaweni yedatha ekhasini lokusebenzela.

Amanothi: Njengoba i-NETWORKDAYS ingaguquki idatha ngokuzenzakalelayo kumafomethi akhokhelwayo, amanani wosuku angeniswe ngqo kumsebenzi wazo zonke izimpikiswano ezintathu kufanele afakwe ngokusebenzisa imisebenzi ka- DATE noma i- DATEVALUE ukuze ugweme amaphutha wokubala, njengoba kuboniswe kulayini 8 wesithombe esihambisana nalesi sihloko .

I-#VALUE! Inani lephutha libuyiselwa uma ngabe ukuphikisana kuqukethe usuku olungavumelekile.

02 ka-03

Isifundo: Bala inani lezinsuku zokusebenza phakathi kwamaDates amabili

Lokhu kufundisa kubonisa indlela ukuhluka okungafani komsebenzi we-NETWORKDAYS kusetshenziselwa ukubala inani lezinsuku zokusebenza phakathi kuka-Julayi 11, 2016, no-Novemba 4, 2016, kuma-Google AmaSpredishithi.

Sebenzisa isithombe esihambisana nalesi sihloko ukulandela kanye nalesi sifundo.

Kulesi sibonelo, amaholide amabili (ngo-September 5 no-Okthoba 10) ayenzeka phakathi nalesi sikhathi futhi anqunywe ku-total.

Isithombe sibonisa ukuthi iziphakamiso zomsebenzi zingangena ngqo kumsebenzi njengamanani wosuku noma njengezinombolo ze-serial noma njengezigcawu zezingcingo endaweni yedatha ekhasini lokusebenzela.

Izinyathelo zokufaka umsebenzi we-NETWORKDAYS

I-Google AmaSpredishithi ayisebenzisi amabhokisi okuxoxa ukuze afake iziphakamiso zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

1. Chofoza kuseli C5 ukuze wenze iseli elisebenzayo .
2. Thayipha uphawu olulinganayo ( = ) olulandelayo igama lezinsuku zenethiwekhi zokusebenza .
3. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngencwadi N.
4. Uma amagama ezinethiwekhi zenethiwekhi ebonakala ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi kanye ne-parenthesis evulekile noma ibakaki nxazonke " ( " esitokisini C5.
5. Chofoza kuseli le- A3 kusikripthi sokusebenzela ukufaka le nkomba yesitokisi njengengxoxo yokuqala_date .
6. Ngemuva kokubhekisela kweseli, thayipha i-comma ukuba uhlukanise phakathi kwezimpikiswano.
7. Chofoza kuseli le- A4 ukungena kulolu chungechunge lwamaseli njenge- end_date argument.
8. Ngemuva kokubhekisela kweseli, thayipha i-comma yesibili.
9. Qinisekisa amaseli A5 no-A6 kushidi lokusebenzela ukuze ufake lolu hlu lwezinkomba zocingo njengengxabano yeholide .
10. Cindezela ukhiye we- Enter ekhibhodi ukuze ungeze abazali bokuvala " ) " futhi uqedele umsebenzi.

Inani lezinsuku zokusebenza-83-livela esitokisini C5 sephepha lokusebenzela.

Uma uchofoza ku-cell C5, umsebenzi ophelele
= I-NETWORKDAYS (A3, A4, A5: A6) ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.

03 ka 03

I-Math Behind Lo msebenzi

Indlela amaSpredishithi e-Google afika ngayo impendulo ye-83 emgqeni wesi-5 ngu:

• Inani lezinsuku zamasonto phakathi kukaJulayi 11 noNovemba 4, 2016, lilingana nama-85 (amaviki angu-17 x 5 izinsuku ngesonto). Umphumela wemigqa engu-3 no-4 lapho ukuphikisana kweholide kukhishiwe.
• Kusukela kulonke, amalanga amabili amaholidi ahlongoziwe (September 5 no-Okthoba 10) asuswa ukuze ashiye imiphumela yama-83 ezinsuku zokusebenza.

Qaphela: Uma izinsuku zezimpelasonto zikhona ngaphandle kweMgqibelo nangeSonto noma usuku olulodwa ngesonto, sebenzisa umsebenzi we-NETWORKDAYS.INTL.