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

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Pierre]

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

Spell out the number as follows using this add-in.

http://orlando.mvps.org/ExcelSpellNumberMore.asp

Pierre

 

[Guest]

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

 

[Guest]

Here's the resource you need:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Thanks Pierre!, it realy works.
Regards,
Muhammad Javaid Hassan