In cell "A1" type-> 10-17-2003
In cell "A2" type-> 09-13-2000
Difference is 3 Years, 1 Months and 4 Days
In cell "A3" paste this formula.
="Difference is "&DATEDIF(A2,(A1),"y"&" Years, "&DATEDIF(A2,(A1),"ym"&" Months and "&DATEDIF(A2,(A1),"md"&" Days"
Also is it always going to be compared to Todays date?
Because that would make a simpler formula.
tav
Webjunk asked for the answer in days, I gave it in a sentence form, which would still require some calculations to get it into days.
So I had to re-write it.
=""&DATEDIF(A2,(A1),"d"
Why I had to put ""& in the formula to get it to work is beyond me.
tav
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.