Sebenzisa umsebenzi we-EOMONTH we-Excel ekufaka / ukukhipha izinyanga ukuya ezinsukwini

01 ka 01

Bala usuku olufanele noma usuku lokuqala ngomsebenzi we-EOMONTH

Umsebenzi we-EOMONTH, omfushane wokusebenza kwenyanga , ungasetshenziselwa ukubala idethi yokuvuthwa noma usuku olufanele lokutshala imali noma iphrojekthi ewela ekupheleni kwenyanga.

Ngokuqondile, lo msebenzi ubuyisela inombolo ye - serial ngosuku lokugcina lenyanga ngenani elibonisiwe lezinyanga ngaphambi noma ngemuva kosuku lokuqala olubalwe.

Umsebenzi ufana kakhulu nomsebenzi we-EDATE , ngaphandle kokuthi izinsuku ze-EDATE zokubuya eziyinani eliqondile lezinyanga ngaphambi noma emva kosuku lokuqala, ngenkathi u-EOMONTH ehlala enezela izinsuku ezanele ukuze afinyelele ekupheleni kwenyanga.

I-Syntax ye-Function ne-Arguments ye-EOMONTH

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

I-syntax yomsebenzi we-EOMONTH yilezi:

= EOMONTH (Qala_kuqala, Izinyanga)

Qala_kudinga - (okudingekayo) usuku lokuqala lophrojekthi noma isikhathi esibucayi

• le mpikiswano ingaba usuku olufakelwe kulo msebenzi, noma ububanzi obuqanjwe noma isitfombe seseli endaweni yedatha ekhasini lokusebenzela.
• uma ireferensi yeseli efakiwe ngosuku lokuqala likhomba esitokisini esingenalutho, umsebenzi uthatha iseli ukuthi libe nenani lezinombolo ze-serial futhi libala usuku lokuphela kube izinyanga eziningi kangaka ngemuva kosuku lokukhohlisa uJanuwari 0, 1900 - njengoba kubonisiwe umugqa 9 wesibonelo.

Izinyanga - (ezidingekayo) inani lezinyanga ngaphambi noma ngemuva kwe- Start_date

• le mpikiswano ingaba usuku olufakelwe kulo msebenzi noma ububanzi obuqanjwe noma isithenjwa sefoni endaweni yedatha kwiphepha 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 kulayini 8 esithombeni ngenhla lapho iminyaka engu-12.25 inqunywe ku-integer 12;

Iphutha Lokubuyisela Inani

Umsebenzi ubuyisela i- #VALUE! inani lephutha uma:

• I-Start_date akuyona idethi evumelekile - njengoba kuboniswe emgqeni wesi-4 esithombeni esingenhla, kusukela ngomhla ka-2/30/2016 (ngoFebhuwari 30, 2016) yisikhathi esingavumelekile;
• izingqikithi zeseli zisetshenziselwa iphuzu lempikiswano leNyanga kwiseli equkethe amanani we-Boolean , idatha yombhalo, noma amanani wephutha .

Umsebenzi ubuyisela i- #NUM! inani lephutha uma:

• I-Start_date ingaphambi kukaJanuwari 1, 1900;
• I-Start_date minus Monus iveza usuku ngaphambi kukaJanuwari 1, 1900.

I-Excel EOMONTH Umsebenzi Wezithombe

Esikhathini esingenhla, i-EOMONTH isebenza ukwengeza nokukhipha inombolo ehlukahlukene yezinyanga kuze kube ngomhla kaJanuwari 1, 2016.

Ulwazi olungezansi luhlanganisa izinyathelo ezisetshenziselwa ukungena kumsebenzi esitokisini B3 sephepha lokusebenzela

Ukufaka umsebenzi we-EOMONTH

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

• Ukuthayipha umsebenzi ophelele: = EOMONTH (A3, C2) ibe yiseli C3;
• Ukukhetha umsebenzi kanye neziphakamiso zayo usebenzisa ibhokisi lengxoxo ye- EOMONTH.

Nakuba kungenzeka nje ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.

Izinyathelo ezingezansi kwekhava zingena emsebenzini we-EOMONTH oboniswe esitokisini B3 esithombeni ngenhla usebenzisa ibhokisi lengxoxo lomsebenzi.

Njengoba inani elizofakwa engxabanweni ye- Months alibi (-6) usuku kumaseli B3 luzoba ngaphambi kosuku lokuqala.

Isibonelo se-EOMONTH - Izinyanga ezikhishwayo

1. Chofoza kuseli B3 - ukwenza iseli esebenzayo;
2. Chofoza kuthebhu yefomu yebhebhoni;
3. Chofoza kumisebenzi yosuku nosuku ukuze uvule uhlu oluhlehlisiwe lomsebenzi;
4. Chofoza I-EOMONTH ohlwini lokukhulisa ibhokisi lengxoxo yomsebenzi;
5. Chofoza ku- Start_date line ebhokisini lengxoxo;
6. Chofoza kuseli le-A3 kusikripthi sokusebenzela ukuze ufake leyo reference reference ebhokisini lengxoxo njenge- Start_date argument;
7. Chofoza kuNyanga Yezinyanga ebhokisini lengxoxo;
8. Chofoza kuseli B2 kushidi lokufaka ukufaka lelo referensi yeseli ebhokisini lebhokisi njengengxabano ye- Months ;
9. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
10. Usuku lwango-7/31/2015 (Julayi 31, 2016) - luvela esitokisini B3 olusuku lokugcina lenyanga oluyizinyanga eziyisithupha ngaphambi kosuku lokuqala;
11. Uma inombolo, efana no-42216, ivela esitokisini B3 cishe kungenzeka ukuthi iseli lifake ukufometha okujwayelekile kulo. Bheka imiyalo engezansi ukuze ushintshe iseli ukufometha okwedlule;
12. Uma uchofoza ku-cell B3 umsebenzi ophelele = I-EOMONTH (A3, C2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

Ukushintsha I-Date Date ku-Excel

Indlela esheshayo futhi elula yokushintsha ifomethi yosuku lamaseli aqukethe umsebenzi we-EOMONTH ukukhetha eyodwa ohlwini lwendlela yokufometha kwangaphambi kokusetha ebhokisini lezingxoxo zefomathi.

Izinyathelo ezingezansi zisebenzisa inhlanganisela yokunciphisa ikhibhodi ye-Ctrl + 1 (inombolo eyodwa) ukuvula ibhokisi lengxoxo yefomathi yefomathi.

Ukushintsha kufomethi yosuku:

1. Qinisekisa amaseli eshidi lokusebenzela eliqukethe noma elizoqukatha izinsuku;
2. Cindezela okhiye be- Ctrl + 1 ukuze uvule ibhokisi lengxoxo yefomathi yefomathi;
3. Chofoza kuthebhu yezinombolo ebhokisini lengxoxo;
4. Chofoza Usuku efasiteleni lohlu lwesigaba (ngakwesokunxele kwebhokisi lengxoxo);
5. Ewindini yohlobo (ngakwesokudla), chofoza kufomethi yosuku olufunayo;
6. Uma amaseli akhethiwe aqukethe idatha, ibhokisi lesampula lizobonisa ukubuka kuqala kwefomethi ekhethiwe;
7. Chofoza inkinobho OK ukulondoloza ushintsho lwefomethi bese uvale ibhokisi lengxoxo.

Kulabo abakhetha ukusebenzisa igundane esikhundleni sekhibhodi, enye indlela yokuvula ibhokisi lengxoxo yilezi:

1. Chofoza ngakwesokudla amaseli akhethiwe ukuvula imenyu yokuqukethwe;
2. 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.