Ukusebenzisa i-DATEDIF ukubala izinsuku, izinyanga, noma iminyaka e-Excel

Bala isikhathi noma umehluko phakathi kwezinsuku ezimbili

I-Excel ineziningana ezimbalwa ezakhiwe emisebenzini yamanje ezingasetshenziswa ukubala inani lezinsuku phakathi kwezinsuku ezimbili.

Umsebenzi wamalanga ngamunye wenza umsebenzi ohlukile ukuze imiphumela ihluke kusuka komunye umsebenzi kuya olandelayo. Yiyiphi oyisebenzisayo, ngakho-ke, incike kwimiphumela oyifunayo.

Umsebenzi we-DATEDIF ungasetshenziswa ukubala isikhathi noma umehluko phakathi kwezinsuku ezimbili. Lesi sikhathi singabalwa ku:

• izinsuku
• izinyanga zonke
• iminyaka yonke

Ukusetshenziswa kwalolu msebenzi kufaka phakathi ukuhlela noma ukubhala iziphakamiso ukucacisa isikhathi seprojekthi ezayo. Ingasetshenziswa futhi, kanye nosuku lomuntu lokuzalwa, ukubala ubudala bakhe eminyakeni, izinyanga, nezinsuku .

I-Syntax ye-Function ne-Arguments ye-DATEDIF

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

I-syntax yomsebenzi we-DATEDIF yi:

= DATEDIF (qala_kudala, ekugcineni_kudlula, eyunithi)

qala_date - (edingekayo) usuku lokuqala lwenkathi ekhethiwe. Usuku lokuqala langempela lungangena kule ngxabano noma ukubhekisela kweseli endaweni yalomdatha ekhasini lokusebenzela kungangena esikhundleni.

end_date - (edingekayo) usuku lokuphela kwesikhathi esikhethiwe. Njenge-Start_date, faka usuku oluphela lokuphela noma ireferensi yeseli endaweni yile datha kushidi lokusebenzela.

i-unit (eyayibizwa ngokuthi ikhefu) - (edingekayo) isitshela umsebenzi ukuthola inombolo yezinsuku ("D"), izinyanga eziphelele ("M"), noma iminyaka ephelele ("Y") phakathi kwezinsuku ezimbili.

Amanothi:

1. I-Excel ithatha izibalo zedethi ngokuguqula izinsuku ezinombolweni yezinhlamvu, eziqala ngo-zero ngosuku lwamaqhinga ngoJanuwari 0, 1900 kuma-computer e-Windows noJanuwari 1, 1904 kumakhompyutha we-Macintosh.
2. Ingxabano yunithi kufanele ifakwe ngamanothi okucaphuna njenge "D" noma "M".

Okuningi kwi-Unit Argument

Ingxabano yeyunithi ingabuye ibe nokuhlanganiswa kwezinsuku, izinyanga, neminyaka ukuze uthole inombolo yezinyanga phakathi kwezinsuku ezimbili ngonyaka ofanayo noma inombolo yezinsuku phakathi kwezinsuku ezimbili ngenyanga efanayo.

• "YD" - sinquma inani lezinsuku phakathi kwezinsuku ezimbili njengokuthi amadethi asemnyaka ofanayo (umugqa 5 ngenhla).
• "YM" - sinquma inani lezinyanga phakathi kwezinsuku ezimbili njengokungathi izinsuku zingumnyaka ofanayo (umugqa 6 ngenhla).
• "MD" - sinquma inani lezinsuku phakathi kwezinsuku ezimbili njengokuthi izinsuku ziyizinyanga ezifanayo nonyaka (umugqa 7 ngenhla).

I-DATEDIF Iphutha Lokusebenza Kwephutha

Uma idatha yezingxabano ezihlukahlukene zalolu msebenzi ayifakiwe ngendlela efanele amanani wephutha alandelayo avela esitokisini lapho umsebenzi we-DATEDIF ukhona khona:

• #VALUE! iphutha - libuyiselwe uma liqala_kuqala noma ukuphela_kudalwa akuzona izinsuku zangempela (umugqa 8 ngaphezulu, lapho iseli A8 iqukethe idatha yombhalo).
• #NUM! iphutha - libuyiselwe uma liphela _date usuku oludlule kune- start_date (umugqa 9 ngenhla).

Isibonelo: Bala ukuthi umehluko phakathi kwezinsuku ezimbili

Iphuzu elithakazelisayo mayelana ne-DATEDIF yukuthi umsebenzi ofihliwe ukuthi awubhalisiwe neminye imisebenzi yoMsuku ngaphansi kwethebhu yefomula ku-Excel, okusho ukuthi:

1. ayikho ibhokisi lengxoxo elitholakalayo lokufaka umsebenzi kanye neziphakamiso zalo.
2. i-tooltip ye-argument ayibonisi uhlu lwezingxabano uma igama lomsebenzi lifakwe esitokisini.

Ngenxa yalokho, umsebenzi kanye nezimpikiswano zawo kufanele kufakwe ngesandla zibe esitokisini ukuze kusetshenziswe, kufaka phakathi ukuthayipha i-comma phakathi kwempikiswano ngayinye yokusebenza njengesahlukanisi.

Isibonelo se-DATEDIF: Ukubala umehluko ezinsukwini

Izinyathelo ezingezansi zihlanganisa indlela yokufaka umsebenzi we-DATEDIF osesithombeni B2 esithombeni ngenhla esibonisa inani lezinsuku phakathi kwezinsuku zingama-4 Meyi 2014 no-Agasti 10, 2016.

1. Chofoza kuseli B2 ukuze wenze iseli elisebenzayo - yilapho inombolo yezinsuku phakathi kwezinsuku ezimbili izoboniswa.
2. Thayipha = datedif ( "esitokisini B2.
3. Chofoza ku-cell A2 ukuze ufaka leli referensi yeseli njengengxoxo yokuqala_date yomsebenzi.
4. Thayipha ikhoma ( , ) esitokisini B2 ngemuva kokubhekisela kweseli A2 ukuze usebenze njengomhlukanisi phakathi kwezingxoxo zokuqala nezesibili.
5. Chofoza kuseli le-A3 kuspredishithi ukuze ufake le nkomba ye-cell njenge-argument end_date.
6. Thayipha ikhompi yesibili ( , ) ngokulandela inkomba ye- A3 yeseli .
7. Ngokuphikisana kweyunithi , thayipha incwadi D ezinqumeni ( "D" ) ukutshela umsebenzi esifuna ukwazi inombolo yezinsuku phakathi kwezinsuku ezimbili.
8. Thayipha i-parenthesis yokuvala ")".
9. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula.
10. Inombolo yezinsuku - 829 - kufanele ivele esitokisini B2 kwiphepha lokusebenzela.
11. Uma uchofoza ku-cell B2 ifomula ephelele = DATEDIF (A2, A3, "D") ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.