01 ngo 01
Bala Umhla wokuKhutshwa okanye uMhla wokuQala kunye nomsebenzi we-EOMONTH
Umsebenzi we-EOMONTH, umfutshane ukulungiselela umsebenzi wokugqibela weNyanga , unokusetyenziswa ukubala umhla wokukhula okanye umhla ofunekayo wokutyalomali okanye iphrojekthi ewela ekupheleni kwenyanga.
Ngokukodwa, umsebenzi ubuyisela inombolo yenombolo yosuku lokugqibela lwenyanga ngenani elibonisiweyo leenyanga ngaphambi okanye emva komhla wokuqala otheliswe.
Umsebenzi ufana kakhulu nomsebenzi we-EDATE , ngaphandle kokuba imihla yokubuyiselwa kwe-EDATE enenani elingaphambili leenyanga ngaphambi okanye emva komhla wokuqala, ngelixa i-EOMONTH ihlala ihlala ifikelele iintsuku ezifikelele ekupheleni kwenyanga.
I-Syntax yeMisebenzi kunye neArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi , iibakaki, abahluli be-comma kunye neengxabano .
I-syntax yomsebenzi we-EOMONTH ngu:
= EOMONTH (Qala_kuqala, iinyanga)
I-Start_date - (efunekayo) umhla wokuqala weprojekthi okanye ixesha elithile kumbuzo
- le ngxabano ingaba ngumhla wangena kumsebenzi, okanye uluhlu oluthiwa igama okanye iselferensi yeseli kwindawo yendawo kwiphepha lokusebenzela.
- ukuba isalathisi engenayo ingena kwisalathisi esingenalutho, umsebenzi uthatha iseli ukuba ibe nenani leenombolo ze-serial kwaye libala ukuba umhla wokuphela ube ziinyanga ezininzi emva komhla wokukhohlisa uJanuwari 0, 1900 - njengoko kuboniswe umgca 9 womzekelo.
Iinyanga - (ezifunekayo) inani leenyanga ngaphambi okanye emva kwe- Start_date
- le ngxabano ingaba ngumhla wangena kumsebenzi okanye uluhlu oluchongiweyo okanye iselferensi yeseli kwindawo yendawo kwiphepha lokusebenzela;
- Iimpawu ezintle zivelisa imihla ezayo - umgca 8 kumfanekiso ongentla;
- Iimpawu ezintle ezidluleyo kumhla - umgca 3 kumfanekiso ongentla;
Ukuba iinyanga aziyiyo inani, inqununu (isahlulo sokugqibela sesuswe) - njengoko kuboniswe kumgca-8 kumfanekiso ongaphezulu apho iminyaka eyi-12.25 inqunywe kwi-integer 12;
Iphutha lokubuyela kwexabiso
Umsebenzi ubuyisela i-#VALUE! ixabiso lesiphene xa:
- I-Start_date ayilona usuku oluvumelekileyo - njengoko kuboniswe kumgca 4 kumfanekiso ongentla, ukususela ngo-2/30/2016 (ngoFebruwari 30, 2016) ngumhla ongavumelekanga;
- Iingxelo zeseli zisetyenziselwa ingxabano yeNyanga kwiseli equkethe ixabiso leBoolean , idata yombhalo, okanye ixabiso lesiphene .
Umsebenzi ubuyisela i-#NUM! ixabiso lesiphene xa:
- I-Start_date ingaphambi koJanuwari 1, 1900;
- I-Start_date minus Iinyanga zivelisa umhla ngaphambi koJanuwari 1, 1900.
Excel EOMONTH Umsebenzi Umzekelo
Kulo mfanekiso ngasentla, i-EOMONTH isebenza ukufaka nokukhupha inani elithile leenyanga ukuya ngomhla kaJanuwari 1, 2016.
Ingcaciso engezantsi iquka amanyathelo asetyenziswa ukufaka umsebenzi kwisisele B3 sephepha lokusebenzela
Ukufaka umsebenzi we-EOMONTH
Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:
- Ukuthayipha umsebenzi opheleleyo: = I-EOMONTH (A3, C2) kwi-cell C3;
- Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yencoko ye -EOMONTH.
Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yababini ukufaka iingxabano zomsebenzi.
Amanyathelo angezantsi angenayo umsebenzi we-EOMONTH oboniswe kwiseli B3 kumfanekiso ongentla usebenzisa ibhokisi yencoko yencoko yomsebenzi.
Ekubeni ixabiso lokungena kwiNgqungquthela yeeNyanga libi (-6) umhla kumaseli eB3 uya kuba ngaphaya komhla wokuqalisa.
UMBONO WONYAKA - Iinyanga ezikhuphayo
- Cofa kwifowuni B3 - ukwenza iseli esebenzayo;
- Cofa kwiThebhu yefomula yerbhoni;
- Cofa ngomhla wexesha kunye nemisebenzi yexesha ukuvula uluhlu lwehla phantsi;
- Cofa kwi EOMONTH kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
- Cofa kwi- Start_date line kwibhokisi yencoko;
- Cofa kwifowuni A3 kwiphepha lokusebenzela ukuze ufake loo ntetho yeselenki kwibhokisi yencoko njenge- Start_date argument;
- Cofa kwiNyanga yeeNyanga kwibhokisi yencoko;
- Cofa kwiseli B2 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko njengeengxabano zenyanga ;
- Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela;
- Umhla wesi-7/31/2015 (ngoJulayi 31, 2016) - ivela kwiseli yeB3 yinto yokugqibela yenyanga enyangeni ezintandathu ngaphambi komhla wokuqalisa;
- Ukuba inombolo, efana no-42216, ibonakala kwiseli B3 mhlawumbi iseli ifomathi jikelele isetyenziswe kuyo. Bona imiyalelo engezantsi ukutshintsha iseli ukufometha komhla;
- Ukuba ucofa kwi-cell B3 umsebenzi opheleleyo = I-EOMONTH (A3, C2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
Ukutshintsha Umhla wohlobo lwe-Excel
Indlela ekhawulezayo kwaye elula yokutshintsha ifomathi yamhla yeeseli equkethe umsebenzi we-EOMONTH kukuba ukhethe enye ukusuka kwisohlomelo lwefom yefom yebhokisi yencoko yefomathi.
Amanyathelo angezantsi basebenzise inhlanganisela yokuncinci yebhodi yebhodi yeChorl + 1 (inombolo enye) ukuvula ibhokisi yencoko yebhokisi yefomathi.
Ukutshintsha kwifomathi yosuku:
- Gqamisa iiseli kwiphepha lokusebenzela eliqukethe okanye eliza kubandakanya imihla;
- Cinezela iifayile ze Ctrl + 1 ukuvula ibhokisi yencoko yebhokisi yefomathi;
- Cofa kwiTebhu yenombolo kwibhokisi yencoko;
- Cofa ngomhla ngomhla wefowuni uludwe lwefestile (kwicala lasekhohlo kwibhokisi yencoko);
- Kwifayile yefayili (kwicala lasekunene), nqakraza kwifom yexesha elifunwayo;
- Ukuba iiseli ezikhethiweyo ziqulethe idatha, ibhokisi leSampula iya kubonisa ukubonwa kwefomathi ekhethiweyo;
- Cofa iqhosha le- OK ukugcina utshintsho lwefomathi uze uvale ibhokisi yencoko.
Kulabo abakhetha ukusebenzisa imouse kunokuba ikhibhodi, enye indlela yokuvula ibhokisi yencoko yile:
- Nqakraza iqhosha lamaseli akhethiweyo ukuvula imenyu yomongo;
- Khetha iifomathi zefomathi ... kwimenyu ukuvula ibhokisi yencoko yencoko yefomathi.
###########
Ukuba, emva kokutshintsha kwifomathi yosuku yeseli, iseli ibonisa uluhlu lweetekisi ze-hashi, kungenxa yokuba iseli ayinabanzi ngokwaneleyo ukubonisa idatha efomathiweyo. Ukwandisa iseli kuya kulungisa ingxaki.