01 ka 01
Engeza / khipha izinyanga ukuya ezinsukwini
HLELA Ukusebenza Okubalulekile
Umsebenzi we-EDATE we-Excel ungasetshenziswa ukufaka ngokushesha noma ukususa izinyanga ezinsukwini ezaziwayo - njengokuvuthwa noma izinsuku ezifanele zokutshala izimali noma izinsuku zokuqala noma zokuphela kwamaphrojekthi.
Njengoba umsebenzi wanezela noma ususa izinyanga zonke kuze kube usuku, umphumela uzohlala njalo ngosuku olufanayo lwenyanga njengosuku lokuqala.
Izinombolo ze-serial
Idatha ebuyiselwe umsebenzi we-EDATE iyinombolo ye- serial noma idethi ye-serial. Faka ukufometha kwosuku kumaseli aqukethe umsebenzi we-EDATE ukuze ubonise izinsuku ezibonakalayo ekhasini lokusebenzela - okuchazwe ngezansi.
I-Syntax ye-EDATE ne-Arguments ye-EDATE
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-EDATE yile:
= EDATE (Qala_kuqala, Izinyanga)
Qala_kudinga - (okudingekayo) usuku lokuqala lophrojekthi noma isikhathi esibucayi
- le mpikiswano ingaba usuku olufakelwe emsebenzini noma isithenjwa sefoni endaweni yedatha ekhasini lokusebenzela
Izinyanga - (ezidingekayo) - inani lezinyanga ngaphambi noma ngemva kwe- Start_date
- le mpikiswano ingaba yinani elifakelwe emsebenzini noma esitokisini sebheli endaweni yedatha ekhasini lokusebenzela
- Izindinganiso ezinhle zinikeza izinsuku ezizayo - irowu 8 esithombeni ngenhla
- Amanani angalungile amadethi adlule - umugqa wesi-3 esithombeni ngenhla
Uma izinyanga zingeyona inamba, inqunywe (ingxenye yesimangadi isusiwe) - njengoba kuboniswe emgqeni 8 esithombeni ngenhla lapho iminyaka engu-12.25 inqunywe ku-integer 12
#VALUE! Inani lephutha
Uma ingxabano ye- Start_date akuyona idethi evumelekile, umsebenzi ubuyisela i- #VALUE! inani lephutha - njengoba kuboniswe kulayini 4 esithombeni ngenhla, kusukela ngo-2/30/2016 (ngoFebhuwari 30, 2016) akuvumelekile
Isibonelo se-EDATE Function Isibonelo
Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sisebenzisa umsebenzi we-EDATE ukwengeza nokususa inombolo ehlukahlukene yezinyanga kuze kube ngomhla kaJanuwari 1, 2016.
Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena emsebenzini kumaseli B3 no-C3 wephepha lokusebenzela .
Ukufaka umsebenzi we-EDATE
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele: = EDATE ($ A $ 3, C2) kuseli C3;
- Ukukhetha umsebenzi kanye nezimpikiswano zayo usebenzisa ibhokisi lokusebenza lomsebenzi we-EDATE .
Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.
Izinyathelo ezingezansi kwekhava zifaka umsebenzi we-EDATE oboniswe esitokisini B3 esithombeni ngenhla usebenzisa ibhokisi lengxoxo lomsebenzi.
Njengoba izindinganiso okufanele zifakwe ezimpikiswaneni ze- Months zibi (-6 no -12) amadethi kumaseli B3 no-C3 azoba ngaphambi kwedethi yokuqala.
Isibonelo se-EDATE - Izinyanga Ezinyakazayo
- Chofoza kuseli B3 - ukwenza iseli esebenzayo;
- Chofoza kuthebhu yefomu yebhebhoni;
- Chofoza kumisebenzi yosuku nosuku ukuze uvule uhlu oluhlehlisiwe lomsebenzi;
- Chofoza HLELA ohlwini ukuze ukhulise ibhokisi lengxoxo lomsebenzi;
- Chofoza ku- Start_date line ebhokisini lengxoxo;
- Chofoza kuseli le-A3 kusikripthi sokusebenzela ukuze ufake leyo reference reference ebhokisini lengxoxo njenge- Start_date argument;
- Cindezela ukhiye we- F4 ekhibhodi ukwenza i-A3 ireferensi yeseli ngokuphelele - $ A $ 3;
- Chofoza kuNyanga Yezinyanga ebhokisini lengxoxo;
- Chofoza kuseli B2 kushidi lokufaka ukufaka lelo referensi yeseli ebhokisini lebhokisi njengengxabano ye- Months ;
- Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela;
- Usuku olungu-7/1/2015 (Julayi 1, 2015) luvela esitokisini B3 ezinyangeni eziyisithupha ngaphambi kosuku lokuqala;
- Sebenzisa isibambo sokugcwalisa ukukopisha umsebenzi we-EDATE kuseli C3 - usuku lwakungu-1/1/2015 (Januwari 1, 2015) kufanele luvele esitokisini C3 ezinyangeni ezingu-12 ngaphambi kosuku lokuqala;
- Uma uchofoza ku-cell C3 umsebenzi ophelele = EDATE ($ A $ 3, C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela;
Qaphela : Uma inombolo, efana no- 42186 , ivela esitokisini B3 cishe kungenzeka ukuthi iseli lifake ukufometha okujwayelekile kulo. Bheka imiyalo engezansi ukuze ushintshe iseli ukufometha okwedlule;
Ukushintsha I-Date Date ku-Excel
Indlela esheshayo futhi elula yokushintsha ifomethi yosuku lamaseli aqukethe umsebenzi we-EDATE ukukhetha eyodwa ohlwini lwamakhethi wokufometha kwangaphambi kokusetha ebhokisini lezingxoxo zefomathi. Izinyathelo ezingezansi zisebenzisa inhlanganisela yokunciphisa ikhibhodi ye-Ctrl + 1 (inombolo eyodwa) ukuvula ibhokisi lengxoxo yefomathi yefomathi.
Ukushintsha kufomethi yosuku:
- Qinisekisa amaseli eshidi lokusebenzela eliqukethe noma elizoqukatha izinsuku
- Cindezela okhiye be- Ctrl + 1 ukuvula ibhokisi lengxoxo yefomathi yefomathi
- Chofoza kuthebhu yezinombolo ebhokisini lengxoxo
- Chofoza Usuku efasiteleni lohlu lwesigaba (ngakwesokunxele kwebhokisi lengxoxo)
- Ewindini yohlobo (ngakwesokudla), chofoza kufomethi yosuku olufunayo
- Uma amaseli akhethiwe aqukethe idatha, ibhokisi lesampula lizobonisa ukubuka kuqala kwefomethi ekhethiwe
- Chofoza inkinobho OK ukulondoloza ushintsho lwefomethi bese uvale ibhokisi lengxoxo
Kulabo abakhetha ukusebenzisa igundane esikhundleni sekhibhodi, enye indlela yokuvula ibhokisi lengxoxo yilezi:
- Chofoza ngakwesokudla amaseli akhethiwe ukuvula imenyu yesimo
- Khetha Amaseli Wefomethi ... kusuka kwimenyu ukuvula ibhokisi lezingxoxo zefomathi yefomathi
###########
Uma, ngemuva kokuguqula kufomethi yamanje yeseli, iseli libonisa umugqa wamathegi we-hashi, kungenxa yokuthi iseli alikho ngokwanele ukubonisa idatha efomatiwe. Ukwandisa iseli kuzolungisa inkinga.