Experts:
Is there a date difference function that returns the number of years, months, and days? I've been searching for a long time for something that would give me the correct answer.
FROM: 02/02/1990
TO: 01/21/1995
The answer should be 4 years, 11 months and 19 days.
I'm using a function that I don't know where it came from because I can't find any information on it in MS Excel help. However, it works like this:
=DATEDIF(F2,G2,"m")/12 when using the FROM and TO dates above gives the incorrect answer 4.9; close, but not correct.
So my question is, how do I create or find a function that is accurate. It would be great if it formatted the text as "4 years, 11 months and 19 days"
Thanks.
Start Free Trial
