Get the Days, Months, & Years Between Dates in Excel (1 Formula)

[@MohammedSaeedAwad]

why i can't find (datedif) equation title in my excel ?

[@TeresaBuenavista-o1j]

That's very helpful. Many thanks!

[@savemoney911]

Can you help me? I am trying to get: Years, Months, Days. This formula works for Years and Months (but no 'days') =DATEDIF(G2,H1,"Y") & " Years, " & DATEDIF(G2,H1,"YM") & " Months " But when I try to add the "Days" like the following, I get an error =DATEDIF(G2,H1,"Y") & " Years, " & DATEDIF(G2,H1,"YM") & " Months ", " & DATEDIF(G2,H1,"YMD") & " Days " Can you help me reveal the Years, Months and Days?

[@cityviewhotel7664]

Great & Thanks a lot for uploading video.

[@VishnuVardhan-vq6bd]

Dear sir please help me this is date of joining 12-04-22 sir present i have date of joining after which how to get my required date by formula

[@nadermounir8228]

A very nice and interesting tutorial 👍 👌

[@alfarhangroup505]

thank you ..very nice Explaintaion

[@முச்சந்தி]

What should I do if I need the answer in this formula? 01 year, 01 Month, 01 Day

[@mmgaffoor]

Great, thankyou

[@jebindavidson]

This is awesome!

[@scopeswabi5809]

Dear Sir, if there is no date in cell B2; then the formula cell shows this *NUM!, kindly tell me how to replace *NUM! with blank cell or show some message like "please put date in cell B2" or any other solution, Kindly answer me.

[@sandeepbhandari3130]

If we read 1 year as 1 year 3 months, then how many years, months and days will there be in 1 year 6 months and 10 days

[@DaviODonnell]

What format change can I make if my date range is 12/1/1985-12/7/1992? It is coming up "7 Years6 Days" but I need it to say "7 Years, 6 Days".

[@pancux670]

Put , after years in your formula. datedif(date1,date2,"y")& "years, "& datedif(date1,date2,"ym")&" months, "&datedif(date1,date2,"md")&" days"

[@syedikramullah1114]

Nice

[@valauramiddleton686]

Now do the same thing for dates before 1900. I am a genealogist.

[@bchill0829]

Dates formula doesn't include end date, 10 FEB 24

[@mehrebevon2561]

❤❤❤

[@sandeepbhandari3130]

Plz make excel formula

[@iceshcratiote3635]

Were og kv

[@user-zf2bk5cz8m]

1 Years? and 1 months? Come on, tidy it up with something like a simple if statement to show Month and Year if singular and Months and Years if plural

[@hokeyfuckstorm]

Agreed. I'm a newbie at Excel but a fanatic about language use. Can you guide me to the correct formula to eliminate plurals when necessary?