Ƙididdige Tarihin Yanzu da Tasirin DATEDIF na Excel

Dole ne ku san shekarun ku (ko wani?)

Ɗaya daga cikin amfani da aikin DATEDIF na Excel shi ne ya lissafa shekarun mutumin. Wannan yana taimakawa cikin yanayi mai yawa.

Ƙididdiga Tarihin Yanzu da DATEDIF

A cikin wannan ƙididdiga, ana amfani da aikin DATEDIF don ƙayyade shekarun da mutum ke ciki a shekaru, watanni da kwanaki.

= DATEDIF (E1, TODAY (), "Y") & "Shekaru," & DATEDIF (E1, TODAY (), "YM") &
"Watanni," & DATEDIF (E1, TODAY (), "MD") & "Ranaku"

Lura : Don yin hanyar da ta fi sauki don aiki tare, ranar haihuwar mutum ta shiga cikin tantanin halitta E1 na takardar aiki. Tunanin tantanin halitta zuwa wannan wuri an shigar da shi a cikin tsari.

Idan kana da kwanan haihuwar da aka adana a cikin sel daban a cikin takardun aiki , tabbas za a canza sauye-sauye guda uku a cikin tsari.

Breaking Down da Formula

Danna kan hoton da ke sama don fadada shi

Ma'anar ta yi amfani da DATEDIF sau uku a cikin tsari don lissafta farkon yawan shekarun, to, adadin watanni, sannan kuma yawan kwanakin.

Sashe uku na wannan tsari shine:

Yawan shekarun: DATEDIF (E1, TODAY (), "Y") & "Shekaru" Yawan watanni: DATEDIF (E1, TODAY (), "YM") & "Watanni" Yawan kwanakin: DATEDIF (E1, TODAY ( ), "MD") & "Ranaku"

Ƙaddamar da Formula Tare

Alamar ampersand (&) alamacciyar alama ce a Excel.

Ɗaya daga cikin yin amfani da shi don haɗawa shine hada bayanai tare da bayanan rubutu yayin da aka yi amfani dashi a cikin guda daya.

Alal misali, ana amfani da ampersand don shiga aikin DATEDIF zuwa rubutun "Shekaru", "Watanni", da "Ranaku" a cikin sassan uku da aka nuna a sama.

A yau () Ayyuka

Ma'anar ta yi amfani da aikin yau () don shigar da kwanan wata a cikin DATEDIF dabara.

Tun da aikin TODAY () ya yi amfani da kwanan watan komfutar don samun kwanan wata, aikin yana ci gaba da ɗaukaka kanta duk lokacin da aka sake yin aikin aiki.

Kayan aiki na al'ada akai-akai recalculate a duk lokacin da aka bude su saboda haka yawan mutumin zai wuce a kowace rana da za a bude aikin aiki sai dai an kashe na'urar ta atomatik.

Misali: Yi lissafin halinka na yanzu tare da DATEDIF

1. Shigar da kwanan haihuwar ku zuwa cikin cell E1 na takardun aiki
2. Rubuta = TODAY () a cikin cell E2. (Zabin). Nuna kwanan nan kamar yadda aka gani a cikin hoton da ke sama, Wannan don kawai kalmarka kawai, ba a amfani da wannan bayanan ta DATEDIF dabara ba.
3. Rubuta ma'anar wannan a cikin cell E3
4. = DATEDIF (E1, TODAY (), "Y") & "Shekaru," & DATEDIF (E1, TODAY (), "YM") & "Watanni,"
   & DATEDIF (E1, TODAY (), "MD") & "Ranaku"

   Lura : Lokacin shigar da bayanan rubutu a cikin wata mahimmanci dole ne a haɗa shi a kalmomi biyu kamar "Years."

5. Danna maballin ENTER akan keyboard
6. Yawan shekarunku na yanzu ya kamata ya bayyana a cikin cell E3 na takardun aiki.
7. Lokacin da ka danna kan salula E3 cikakken aikin ya bayyana a cikin maɓallin tsari a sama da takardun aiki