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?
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.
That's very helpful. Many thanks!
why i can't find (datedif) equation title in my excel ?
Just type it in
Thank You!
Great & Thanks a lot for uploading video.
A very nice and interesting tutorial 👍 👌
This is awesome!
Great, thankyou
thank you ..very nice Explaintaion
What should I do if I need the answer in this formula?
01 year, 01 Month, 01 Day
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?
It's not YMD, it's just MD
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
Nice
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
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".
Put , after years in your formula. datedif(date1,date2,"y")& "years, "& datedif(date1,date2,"ym")&" months, "&datedif(date1,date2,"md")&" days"
When I follow the very first step I get a value error
Now do the same thing for dates before 1900. I am a genealogist.
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.
Just type IFERROR before the DATEDIF function and in the end put your required comment within " ". remember to put necessary brackets.
Plz make excel formula
❤❤❤
Dates formula doesn't include end date, 10 FEB 24
Were og kv
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
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?