Bala i-Current Age yakho kunye ne-Excel DATEDIF Umsebenzi

Ngaba ufuna ukwazi iminyaka yakho (okanye omnye umntu?)

Esinye isisiseko somsebenzi we-Excel sika-DATEDIF ukubala ubudala bomntu. Oku kunceda kwiimeko ezahlukeneyo.

Bala i-Current Age yakho kunye neDATEDIF

Kule ndlela elandelayo, umsebenzi we-DATEDIF usetyenziselwa ukuchonga ubudala obukhoyo bomntu kwiminyaka, inyanga kunye neentsuku.

= DATEDIF (E1, TODAY (), "Y") & "Iminyaka," & DATEDIF (E1, TODAY (), "YM") &
"Iinyanga," & DATEDIF (E1, TODAY (), "MD") & "Iintsuku"

Qaphela : Ukwenza ukuba ifomula ilula ukusebenza kunye, umhla wokuzalwa komntu ungena kwiseli E1 kwiphepha lokusebenzela. Ukubhekisele kweseli kule ndawo kungeniswa kwifom.

Ukuba unomhla wokuzalwa ogcinwe kwiseli eyahlukileyo kwiphepha lokusebenzela , qiniseka ukuba utshintshe iinkcazo ezintathu zeefom kwifom.

Ukuqhawula i-Formula

Cofa kumfanekiso ongentla ukuze ukwandise

Ifomula isebenzisa i-DATEDIF ngamaxesha amathathu kwifomula ukubala kuqala inani leeminyaka, ngoko inani leenyanga, kunye nenani leentsuku.

Iingxenye ezintathu zefomula zi:

Inani leminyaka: I- DATEDIF (E1, TODAY (), "Y") & "Iminyaka" Inani leenyanga: DATEDIF (E1, TODAY (), "YM") & "Iinyanga" Inani leentsuku: DATEDIF (E1, TODAY ( ), "MD") & "Iintsuku"

Ukubambisana kweFormula ndawonye

I-ampersand (&) iyisimboli se- concatenation kwi-Excel.

Ukusetyenziswa komnye ukugqithiswa kukudibanisa idatha yeenkcukacha kunye nedatha yombhalo xa kusetshenziselwa ndawonye kwifomula enye.

Umzekelo, i-ampersand isetyenziselwa ukujoyina umsebenzi we-DATEDIF kumbhalo othi "iminyaka", "inyanga" kunye "neentsuku" kumacandelo amathathu kwendlela eboniswe ngasentla.

NAMUHLA () Umsebenzi

Ifom ye-formula ibuye isebenzise umsebenzi we-TODAY () ukufaka umhla okhoyo kwifom ye-DATEDIF.

Ekubeni umsebenzi we-TODAY () usebenzisa usuku lwe-serial kwikhompyutha ukufumana umhla okhoyo, umsebenzi uyazihlaziya rhoqo rhoqo xa iphetshana lokusebenzela lihlelwa kwakhona.

Ngokuqhelekileyo amaxwebhu okusebenzela aphinde ahlaziywe rhoqo xa evuliwe ukwenzela ukuba iminyaka yobudala bomntu iya kunyuka imihla yonke ukuba iphepha lokusebenzela livulwe ngaphandle kokuba ukucima ngokuzenzekelayo kuvaliwe.

Umzekelo: Bala i-Current Age yakho kunye neDATEDIF

1. Faka usuku lwakho lokuzalwa kwiseli E1 kwiphepha lokusebenzela
2. Uhlobo = TODAY () kwi-cell E2. (Okokukhetha). Ubonisa umhla okhoyo njengoko uboniswe kumfanekiso ongentla, Oku kungokwentetho yakho kuphela, le data ayisebenzisi ifom ye-DATEDIF ngezantsi
3. Thayipha ifom elandelayo kwiseli E3
4. = DATEDIF (E1, TODAY (), "Y") & "Iminyaka," & DATEDIF (E1, TODAY (), "YM") & "Inyanga,"
   & DATEDIF (E1, TODAY (), "MD") & "Iintsuku"

   Qaphela : Xa ufaka idatha yombhalo kwifomu kufuneka ifakwe kwiimpawu zokucaphulwa kabini ezifana "iminyaka."

5. Cinezela i- ENTER iqhosha kwikhibhodi
6. Ubudala bakho obufunekayo kufuneka bubonakale kwiseli ye-E3 yeshidi lomsebenzi.
7. Xa ucofa kwi-cell E3 umsebenzi opheleleyo uvela kwibha yefomula ngaphezulu kwephepha lokusebenzela