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

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

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

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

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

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

Muhammad Javaid Hassan wrote:
> 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

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

"Ron Coderre" wrote:

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

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

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

XL2002, WinXP


"Muhammad Javaid Hassan" wrote:

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

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

"Pierre" wrote:

>
> Muhammad Javaid Hassan wrote:
> > 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
>
>