Amapredishithi e-Google anemisebenzi yamanje eyakhelwe ngaphakathi engasetshenziselwa ukubalwa kwezinsuku zokusebenza.
Umsebenzi wamalanga ngamunye wenza umsebenzi ohlukile ukuze imiphumela ihluke kusuka komunye umsebenzi kuya olandelayo. Yiyiphi oyisebenzisayo, ngakho-ke, incike kwimiphumela oyifunayo.
01 ka-03
Umsebenzi we-WORKDAY.INTL
I-Google Spreadsheets ye-WORKDAY.INTL Umsebenzi
Endabeni yomsebenzi we-WORKDAY.INTL, ithola usuku lokuqala noma lokuphela kwephrojekthi noma isabelo esinikezwe inombolo ehleliwe yosuku lokusebenza.
Izinsuku ezicacisiwe njengezinsuku zeveki zikhishwa ngokuzenzakalelayo kusukela kuphelele. Ngaphezu kwalokho, izinsuku ezithile, njengamaholidi asemthethweni, zingashiywa futhi.
Indlela umsebenzi we-WORKDAY.INTL ohluke ngayo emsebenzini we-WORKDAY ukuthi i-WORKDAY.INTL ikuvumela ukuba ucacise ukuthi yiziphi izinsuku nokuthi zingaki izinsuku ezibhekwa njengezinsuku zeveki kuphela kunokususa ngokuzenzakalelayo izinsuku ezimbili ngesonto - ngoMgqibelo nangeSonto - kusukela enani lezinsuku.
Ukusetshenziswa komsebenzi we-WORKDAY.INTL kubandakanya ukubala:
- usuku lokuphela kwephrojekthi enezinombolo zokusebenza izinsuku ezilandelayo ngosuku oluthile olunikeziwe
- usuku lokuqala lwephrojekthi enezinombolo zomsebenzi wezinsuku zokusebenza ngaphambi kosuku lokuphela olunikeziwe
- usuku olufanele lwe-invoyisi
- usuku lokulethwa kulindeleke lwezimpahla noma izinto
I-Syntax ne-Arguments ye-WORKDAY.INTL
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-WORKDAY yile:
= WORKDAY.INTL (qala_kuqala, ama-num_days, ngempelasonto, amaholide)
qala_date - (edingekayo) usuku lokuqala lwenkathi ekhethiwe
- usuku langempela lokuqala lungangena kule ngxabano noma ukubhekisela kweseli endaweni yale datha kushidi lokufaka ungafakwa esikhundleni
inombolo_zinsuku - (ezidingekayo) ubude bephrojekthi
- kule ngxabano, faka inamba ekhombisa inani lezinsuku zomsebenzi ezenziwe kule phrojekthi
- faka inani langempela lezinsuku zomsebenzi - njenge-82 - noma ireferensi yeseli endaweni yile datha kushidi lokusebenzela
- ukuthola usuku olwenzeka ngemuva kokungqubuzana kokuqala_date, sebenzisa inombolo enhle yama-num_suku
- ukuthola usuku olwenzeka ngaphambi kokungqubuzana kwe-start_date, sebenzisa inani eliphelele lezinombolo ezingu-NUM
ngempelasonto - (okukhethwa kukho) kubonisa ukuthi yiziphi izinsuku zesonto ezibhekwa njengezinsuku zezimpelasonto futhi zingabandakanyi lezi zinsuku kusukela ezinsukwini zokusebenza zokusebenza
- kule ngxabano, faka ikhodi yenombolo yeviki noma isithenjwa sefoni endaweni yile datha kushidi lokusebenzela
- uma le mpikiswano ingavaliwe, okuzenzakalelayo 1 (ngoMgqibelo nangeSonto) isetshenziselwa ikhodi yezimpelasonto
- bona uhlu oluphelele lwamakhodi wezinombolo ekhasini 3 lale tutorial
amaholidi - (okukhethwa kukho) izinsuku ezilodwa noma ngaphezulu ezengeziwe ezingabalwa kusukela enani lezinsuku zokusebenza zokusebenza
- izinsuku zeholide zingangenwa njengezinombolo zosuku lokudala noma izinkomba zeseli endaweni yokubaluleka kwamalanga ekhasini lokusebenzela
- uma izingqikithi zeseli zisetshenziselwa, amanani wesikhathi kufanele afakwe kumaseli asebenzisa imisebenzi ka- DATE , DATEVALUE noma TO_DATE ukuze agweme amaphutha okungenzeka
Isibonelo: Thola Usuku Lokuphela Lwephrojekthi nomsebenzi we-WORKDAY.INTL
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sizosebenzisa umsebenzi we-WORKDAY.INTL ukuthola usuku lokuphela kwephrojekthi eqala ngoJulayi 9, 2012 futhi iqede izinsuku ezingu-82 kamuva.
Amaholide amabili (September 3 no-Okthoba 8) okwenzeka phakathi nalesi sikhathi ngeke kubalwe njengengxenye yezinsuku ezingu-82.
Ukuze ugweme izinkinga zokubala ezingahle zenzeke uma izinsuku zingena ngengozi njengombhalo, umsebenzi we-DATE uzosetshenziselwa ukungena izinsuku ezisetshenziswe njengezingxabano. Bona isigaba se- Error Values section ekupheleni kwalesi sifundo ngolwazi oluthe xaxa.
Ukufaka idatha
I-A1: Usuku Lokuqala: A2: Inombolo Yezinsuku: A3: Iholide 1: A4: Iholide 2: A5: Usuku Lokuphela: B1: = DATE (2012,7,9) B2: 82 B3: = UMHLABA (2012,9,3 ) B4: = UMHLABA (2012,10,8)- Faka idatha elandelayo kwiseli elifanele:
Uma izinsuku kumaseli b1, B3, no-B4 zingabonakali njengoba kuboniswe esithombeni ngenhla, hlola ukuze ubone ukuthi lawa maseli afomathiwe ukuze abonise idatha esebenzisa ifomethi yosuku olufushane.
02 ka-03
Ukufaka umsebenzi we-WORKDAY.INTL
Ukufaka umsebenzi we-WORKDAY.INTL
Amaspredishithi e-Google awasebenzisi amabhokisi okuxoxa ukuze afake iziphakamiso zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.
- Chofoza kuseli B6 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-WORKDAY.INTL izoboniswa
- Thayipha uphawu olulinganayo (=) olulandelayo igama lomsebenzi wokusebenza , i-intl
- Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama kanye ne-syntax yemisebenzi eqala ngohlamvu W
- Uma igama elithi WORKDAY.INTL livela ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi bese uvula ibakaki nxazonke esitokisini B6
Ukufaka iziphakamiso zomsebenzi
Njengoba kuboniswe esithombeni ngenhla, izingxabano zomsebenzi we-WORKDAY.INTL zingenwa ngemuva kokufaka ibhokisi elivulekile esitokisini B6.
- Chofoza kuseli B1 kushidi lokusebenzela ukuze ufake le nkomba ye-cell njenge-argument start_date
- Ngemuva kokubhekisela kweseli, thayipha i-comma ( , ) ukuze wenze njengesahlukanisi phakathi kwezimpikiswano
- Chofoza kuseli B2 ukungena kule nkomba yebheli njengengxabano ye- num_days
- Ngemuva kokubhekisela kweseli, thayipha enye i-comma
- Chofoza kuseli B3 ukungena kulolu chungechunge lwamaseli njengokungqubuzana kweviki
- Qinisekisa amaseli B4 no-B5 kushidi lokufaka ukuze ufake lezi zikhombo zeseli njengengxabano yeholidi
- Cindezela ukhiye wokungena kwikhibhodi ukuze ufake ibhakha lokuvala " ) " emva kokuphikisana kokugcina nokuqedela umsebenzi
- Usuku lomhla ka-11/29/2012 - usuku lokuphela kweprojekthi - kufanele luvele esitokisini B6 sephepha lokusebenzela
- Uma uchofoza ku-cell b5 umsebenzi ophelele
= WORKDAY.INTL (B1, B2, B3, B4: B5) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela
Izibalo ngemuva komsebenzi
Indlela i-Excel ebala ngayo lolu suku yilo:
- Usuku olunezinsuku ezingu-82 zokusebenza ngemuva kuka-Agasti 5, 2012, nguNovemba 27 (usuku lokuqala akubalwa njengenye yezinsuku ezingu-82 umsebenzi we-WORKDAY.INTL)
- Ngezela kulolu suku izinsuku eziyisikhathi zokuzalwa ezichazwe (Agasti 19 noNovemba 15) ezingazange zibalwa njengengxenye yempikiswano yezinsuku ezingu- 82
- Usuku lokuphela kwalolu hlelo, ke, ngoLwesine, Novemba 29, 2012
I-WORKDAY.INTL Ama-Error Value Value
Uma idatha yezingxabano ezihlukahlukene zalolu msebenzi ayifakiwe ngendlela efanele amanani wephutha alandelayo avela esitokisini lapho umsebenzi we-WORKDAY ukhona:
- #VALUE! : ivela engxenyeni yesiphenduli Uma esinye seziphakamiso ze-WORKDAY akusona usuku oluvumelekile (uma usuku lufakwe njengombhalo ngokwesibonelo)
- #NUM !: ivela engxenyeni yesiphenduli uma usuku olungavumelekile luphumela ekungeza izimpendulo ze - Start_date kanye nezinsuku
- Uma ukungqubuzana kwezinsuku kungenwe njenge-integer - njengezinsuku ezingu-83.25 - inombolo izofakwa eceleni kwenani eliphelele lenombolo: izinsuku ezingu-83
03 ka 03