Don ƙididdige tsawon tazarar kwanan wata a cikin Excel akwai aiki RAZNDAT, a cikin Ingilishi - DATEDIF.
Nuance shine ba za ku sami wannan aikin ba a cikin jerin Mayen Aiki ta danna maɓallin fx - siffa ce ta Excel mara izini. Bugu da ƙari, za ka iya samun bayanin wannan aikin da kuma gardama kawai a cikin cikakken fassarar taimakon Ingilishi, tun da yake an bar shi don dacewa da tsofaffin sassan Excel da Lotus 1-2-3. Duk da haka, duk da cewa ba za a iya shigar da wannan aikin a cikin daidaitattun hanyar ta taga ba Saka - Aiki (Saka - Aiki), Kuna iya shigar da shi da hannu a cikin tantanin halitta daga maɓalli - kuma zai yi aiki!
Haɗin aikin shine kamar haka:
=RAZNDAT(Ranar farawa; Kwanan wata ƙarshe; Hanyar_ma'auni)
Tare da muhawara biyu na farko, duk abin da ya fi ko žasa bayyananne - waɗannan su ne sel tare da kwanakin farawa da ƙarshen. Kuma hujja mafi ban sha'awa, ba shakka, ita ce ta ƙarshe - yana ƙayyade daidai yadda kuma a cikin wace raka'a za a auna tazara tsakanin kwanakin farawa da ƙarshen. Wannan siga na iya ɗaukar dabi'u masu zuwa:
"Da" | cikakken shekara bambanci |
"M" | cikin cikakkun watanni |
"D" | cikin cikakkun kwanaki |
"yd" | bambancin kwanakin tun farkon shekara, ban da shekaru |
"Md" | bambanci a cikin kwanaki ban da watanni da shekaru |
"in" | bambanci a cikakkun watanni ban da shekaru |
Misali:
Wadancan. idan kuna so, ƙididdigewa da nunawa, alal misali, ƙwarewar ku ta hanyar "3 shekaru 4 watanni. Kwanaki 12”, dole ne ku shigar da dabara mai zuwa a cikin tantanin halitta:
u1d RAZDAT (A2; A1; "y")&" y. "& RAZDAT (A2; A1; "ym") & "wata. "&RAZDAT(A2;AXNUMX;"md")&"kwanaki"
inda A1 shine tantanin halitta tare da kwanan watan shiga aiki, A2 shine ranar korar.
ko a cikin Ingilishi na Excel:
=DATEDIF(A1;A2;»y»)&» y. «&DATEDIF(A1;A2;»ym»)&» m. «&DATEDIF(A1;A2;»md»)&» d.
- Yadda ake yin faɗuwar kalanda don shigar da kowace rana da sauri tare da linzamin kwamfuta a kowace tantanin halitta.
- Yadda Excel ke aiki tare da kwanakin
- Yadda ake shigar da kwanan watan ta atomatik a cikin tantanin halitta.
- Yadda za a gano idan tazarar kwanan wata biyu sun yi karo da kwanaki nawa