How do I calculate exact difference between two dates in y,m,d
OK....see if this makes sense
With 14.02.1980 to 01/04.1995
Feb-14-1980 to Feb-14-1995: 1 year
Feb-14-1995 to Mar-14-1995: 1 month
Mar-14-1995 to Apr-01-1995: 18 days
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Muhammad Javaid Hassan" wrote:
Thanks for the feedback, try the formula on 14.02.1980 to 01.04.1995, the
result is
15 years, 1 month, 18 days whereas actual difference is 15 years, 1 month,
17 days.
"Ron Coderre" wrote:
When I copied your formula from the screen and pasted it into Excel, it
returned:
5Years, 0Months, 7Days.
That value is correct.
You don't mention what value is returned by the formula you used.
***********
Regards,
Ron
XL2002, WinXP
"Muhammad Javaid Hassan" wrote:
I tried to callculate the difference between 14.02.1980 and 21.02.1985, but
excel does not give the exact difference in years, months and days.
I used the formula
=DATEDIF(A10,B10,"Y")&"Years, "&DATEDIF(A10,B10,"YM")&"Months,
"&DATEDIF(A10,B10,"MD")&"Days."
|