I-Excel EDATE Umsebenzi

01 ngo 01

Yongeza / Ukhuphe iNyanga ukuya kwiiNkcukacha

HLAWULISA U msebenzi

Umsebenzi we-EDATE we-Excel ungasetyenziselwa ukufaka ngokukhawuleza okanye ukukhupha inyanga ukuya kwiindawo ezaziwayo - njengokukhula okanye iintsuku zokutyalomali okanye iintsuku zokuqalisa okanye zokuphela kweeprojekthi.

Ekubeni umsebenzi wongeza okanye ususe zonke iinyanga ukuya kumhla, umphumo uya kuhlala uhlala ngosuku olufanayo lwenyanga njengosuku lokuqala.

Nerial Numbers

Idatha ebuyiselwe ngumsebenzi we-EDATE yinombolo yecala okanye umva we-serial. Faka isicelo sokufometha komhla kwiiseli eziqukethe umsebenzi we-EDATE ukuze ubonise imihla ebonakalayo kwiphepha lokusebenzela - elichazwe ngezantsi.

I-Syntax yeMisebenzi ye-EDATE kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .

I-syntax yomsebenzi we-EDATE ngu:

= EDATE (Qala_kuqala, iinyanga)

I-Start_date - (efunekayo) umhla wokuqala weprojekthi okanye ixesha elithile kumbuzo

• le ngxabano ingaba ngumhla wangena kumsebenzi okanye iselferensi yeseli kwendawo yedatha kwiphepha lokusebenzela

Iinyanga - (ezifunekayo) - inani leenyanga ngaphambi okanye emva kwe- Start_date

• le ngxabano ingaba yinani elifakelwe kumsebenzi okanye isetyenzisi yeseli kwendawo yedatha kwiphepha lokusebenzela
• Iimpawu ezintle zivelisa imihla ezayo - umgca 8 kumfanekiso ongentla
• Iimpawu ezintle ezidlulileyo iintsuku - umgca 3 kumfanekiso ongentla

• Ukuba iinyanga aziyiyo inani, inqununu (isahlulo sokugqibela isuswe) - njengoko kuboniswe kumgca-8 kumfanekiso ongaphezulu apho iminyaka eyi-12.25 inqunywe kwi-integer 12

#VALUE! Iphutha lexabiso

Ukuba ingxoxo ye- Start_date ayilona usuku oluvumelekileyo , umsebenzi ubuyisela i- #VALUE! Ixabiso lephutha - njengoko kuboniswe kumgca 4 kumfanekiso ongentla, ukususela ngo-2/30/2016 (ngoFebruwari 30, 2016) akuvumelekanga

Umzekelo we-EDATE Function Example

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo usebenzisa umsebenzi we-EDATE ukuba ungeze kwaye ususe inani elithile leenyanga ukuya ngomhla kaJanuwari 1, 2016.

Ingcaciso engezantsi iquka amanyathelo asetyenziswa ukufaka umsebenzi kumaseli B3 no-C3 kwiphepha lokusebenzela .

Ukufaka umsebenzi we-EDATE

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

• Ukuthayipha umsebenzi opheleleyo: = EDATE ($ A $ 3, C2) kwi-cell C3;
• Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yencoko ye -EDATE .

Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yababini ukufaka iingxabano zomsebenzi.

Amanyathelo angezantsi angena kumsebenzi we-EDATE oboniswe kwiseli B3 kumfanekiso ongentla usebenzisa ibhokisi yencoko yencoko yomsebenzi.

Ekubeni amaxabiso angeniswa kwiingxabano zeNyanga ziyiyo (negative and -12) imihla ngemihla kwiiseli zeB3 kunye neC3 ziya kuba ngaphaya komhla wokuqalisa.

UMHLA WESIGABA - Ukukhupha iinyanga

1. Cofa kwifowuni B3 - ukwenza iseli esebenzayo;
2. Cofa kwiThebhu yefomula yerbhoni;
3. Cofa ngomhla wexesha kunye nemisebenzi yexesha ukuvula uluhlu lwehla phantsi;
4. Cofa kwi HLAWULA kuluhlu ukuzisa ibhokisi yencoko yencoko yomsebenzi;
5. Cofa kwi- Start_date line kwibhokisi yencoko;
6. Cofa kwifowuni A3 kwiphepha lokusebenzela ukuze ufake loo ntetho yeselenki kwibhokisi yencoko njenge- Start_date argument;
7. Cinezela iqhosha le- F4 kwikhibhodi ukwenza i-A3 isalathisi esele ngokupheleleyo - $ A $ 3;
8. Cofa kwiNyanga yeeNyanga kwibhokisi yencoko;
9. Cofa kwiseli B2 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko njengeengxabano zenyanga ;
10. Cofa u-OK ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela;
11. Umhla we-7/1/2015 (ngoJulayi 1, 2015) - uvela kwiseli yeB3 eneenyanga ezintandathu ngaphambi komhla wokuqalisa;
12. Sebenzisa isibambo sokuzalisa ukukopisha umsebenzi we-EDATE kwisisele C3 - umhla we-1/1/2015 (ngoJanuwari 1, 2015) kufuneka uvele kwiseli C3 elineenyanga ezili-12 ngaphambi komhla wokuqalisa;
13. Ukuba ukhekha kwi-cell C3 umsebenzi opheleleyo = EDATE ($ A $ 3, C2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela;

Qaphela : Ukuba inombolo, efana no- 42186 , ibonakala kwiseli B3 mhlawumbi iseli ifomathi jikelele isetyenziswe kuyo. Bona imiyalelo engezantsi ukutshintsha iseli ukufometha komhla;

Ukutshintsha Umhla wohlobo lwe-Excel

Indlela ekhawulezayo kwaye elula yokutshintsha ifomathi yamhla yeeseli eziqukethe umsebenzi we-EDATE kukuba ukhethe enye ukusuka kwisohlomelo lwendlela yokufometha kwangaphambili kwibhokisi yencoko yencoko yefomathi. Amanyathelo angezantsi basebenzise inhlanganisela yokuncinci yebhodi yebhodi yeChorl + 1 (inombolo enye) ukuvula ibhokisi yencoko yebhokisi yefomathi.

Ukutshintsha kwifomathi yosuku:

1. Gqamisa iiseli kwiphepha lokusebenzela eliqukethe okanye eliza kubandakanya imihla
2. Cinezela iifayile ze Ctrl + 1 ukuvula ibhokisi yencoko yebhokisi yefomathi
3. Cofa kwiTebhu yenombolo kwibhokisi yencoko
4. Cofa ngomhla ngomhla wefayile uludwe lwefestile (kwicala lasekhohlo kwibhokisi yencoko)
5. Kwifayile yefayili (kwicala lasekunene), nqakraza kwifom yexesha elifunwayo
6. Ukuba iiseli ezikhethiweyo ziqulethe idatha, ibhokisi leSampula liya kubonisa imbonakalo yefomathi ekhethiweyo
7. Cofa iqhosha le- OK ukugcina utshintsho lwefomathi uze uvale ibhokisi yencoko

Kulabo abakhetha ukusebenzisa imouse kunokuba ikhibhodi, enye indlela yokuvula ibhokisi yencoko yile:

1. Nqakraza iqhosha lamaseli akhethiweyo ukuvula imenyu yomongo
2. 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.