Bala i-Current Age yakho ne-Excel DATEDIF Umsebenzi

Udinga ukwazi iminyaka yakho (noma omunye umuntu?)

Ukusetshenziswa okukodwa komsebenzi we- Excel ka-DATEDIF ukubala iminyaka yobudala bomuntu. Lokhu kuyasiza ezimweni ezihlukahlukene.

Bala i-Current Age yakho nge-DATEDIF

Kulamakhelo alandelayo, umsebenzi we-DATEDIF usetshenziselwa ukunquma ubudala bomuntu wamanje eminyakeni, izinyanga nezinsuku.

= DATEDIF (E1, TODAY (), "Y") & "Iminyaka," & DATEDIF (E1, TODAY (), "YM") &
"Izinyanga," & DATEDIF (E1, TODAY (), "MD") & "Izinsuku"

Qaphela : Ukwenza ifomula ibe lula ukusebenza, usuku lokuzalwa lomuntu lungena esitokisini E1 sephepha lokusebenzela. Ukubhekisela kweseli kule ndawo bese kungena kufomula.

Uma unosuku lokubeletha elondolozwe esitokisini esithile kuphepha lokusebenzela , qiniseka ukuthi ushintshe izinkomba ezintathu zefomula kwifomula.

Ukuqeda Iformula

Chofoza kusithombe esingenhla ukuze usikhulise

Ifomula isebenzisa i-DATEDIF izikhathi ezintathu kwifomula ukubala kuqala inani leminyaka, bese inamba yezinyanga, bese kuba nenani lezinsuku.

Izingxenye ezintathu zefomula ziyi:

Inani leminyaka: DATEDIF (E1, TODAY (), "Y") & "Iminyaka" Inani lezinyanga : DATEDIF (E1, TODAY (), "YM") & "Izinyanga" Inani lezinsuku: DATEDIF (E1, TODAY ( ), "MD") & "Izinsuku"

Ukubambisana ne-Formula Together

I-ampersand (&) iyisimboli sokuncintisana ku-Excel.

Ukusetshenziswa okukodwa kokuncintisana ukujoyina idatha yocingo kanye nedatha yombhalo ndawonye uma isetshenziselwa ndawonye kwifomula elilodwa.

Isibonelo, i-ampersand isetshenziselwa ukujoyina umsebenzi we-DATEDIF emibhalweni ethi "Iminyaka", "Izinyanga", ne "Izinsuku" ezingxenyeni ezintathu zefomula eliboniswe ngenhla.

NOMSEBENZI () Umsebenzi

Ifomula iphinde isebenzise umsebenzi we-TODAY () ukufaka usuku lwamanje kufomula ye-DATEDIF.

Njengoba umsebenzi we-TODAY () usebenzisa usuku lwe- serial ye -computer ukuze uthole usuku lwamanje, lo msebenzi uhlale uvuselela wona njalo uma ishidi lomsebenzi lihlelwa kabusha.

Ngokujwayelekile ama-worksheet aphinde avuselele isikhathi ngasinye lapho evuliwe ngakho iminyaka yobudala bomuntu izokhuphula nsuku zonke ukuthi iphepha lokusebenzela livuliwe ngaphandle kokuthi ukuvuselelwa okuzenzakalelayo kuvaliwe.

Isibonelo: Bala i-Current Age yakho no-DATEDIF

1. Faka idethi yakho yokuzalwa ibe yiseli E1 yephepha lokusebenzela
2. Thayipha = NAMUHLA () ku-E2 cell. (Okokuzithandela). Ibonisa usuku lwangoku njengoba lubonisiwe esithombeni esingenhla, Lokhu kungokwakho kuphela, le datha ayisebenzisi ifomu le-DATEDIF ngezansi
3. Thayipha ifomu elilandelayo ku-cell E3
4. = DATEDIF (E1, TODAY (), "Y") & "Iminyaka," & DATEDIF (E1, TODAY (), "YM") & "Izinyanga,"
   & DATEDIF (E1, TODAY (), "MD") & "Izinsuku"

   Qaphela : Uma ufaka idatha yombhalo kwifomula kumele ifakwe emamaki okucaphuna kabili anjenge "Iminyaka."

5. Cindezela inkinobho ENTER ekhibhodi
6. Isikhathi sakho samanje kufanele sivele esitokisini E3 sephepha lokusebenzela.
7. Uma uchofoza kumakhalekhukhwini E3 umsebenzi ophelele uvela kubha yefomula ngaphezulu kwephepha lokusebenzela