How do I calculate exact difference between two dates in y,m,d.

  • Thread starter Muhammad Javaid Hassan
  • Start date
M

Muhammad Javaid Hassan

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."
 
R

Ron Coderre

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
 
M

Muhammad Javaid Hassan

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.
 
R

Ron Coderre

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
 
M

Muhammad Javaid Hassan

Thanks, yes it has sense and now I understand how Excel calculates the
difference in dates which seems the correct way. I have another problem,
please help me on that if you or anybody else can. I need to convert amount
written in one cell in figures ($20500) in words in the next cell or any
other cell (Dollar Twenty Thousand Five Hundred Only). Is there any formula
in Excell for that.
Regards,
Muhammad Javaid Hassan
 
M

Muhammad Javaid Hassan

Thanks, I think it make sense. Actually it is the way Excel works out the
difference in two dates and seems the correct way.
I have another problem, please you or anyone help me on this if possible.
I am trying to convert amount written in one cell in figures ($20560) to
amount in words in the next or any other cell (Dollar Twenty Thousand Five
Hundred Sixty Only). Can it be done in Excel?
Regards,
Muhammad Javaid Hassan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top