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

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.

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

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

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

Thanks Pierre!, it realy works.
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.