Date problem

[@Homeonthecouch]

I am wanting to work out the time difference between two dates.
Lets say 1/1/2000 to 10/4/2003
I want the answer to be displayed in a years months and days format.
The answer to the above would be reported back as 3 years 3 months and 9
days.
Is this possible to do?


Any help is appreciated


Andrew

 

[Pete_UK]

Hi Andrew,

Chip Pearson explains how to do this here:

http://www.cpearson.com/excel/datedif.htm

Hope this helps.

Pete

 

[Gord Dibben]

Use the undocumented DATEDIF function.

=DATEDIF(A6,A7,"y") & "years," & DATEDIF(A6,A7,"ym") & "months,"&
DATEDIF(A6,A7,"md") & "days,"

A6 is earliest date, A7 is latest date.

For more on DATEDIF see Chip Pearson's site.

http://www.cpearson.com/excel/datedif.htm


Gord Dibben MS Excel MVP

 

[@Homeonthecouch]

Many thanks that's a great help and I loved the "one of the drunk cousins of
the Function Family" comment
That is a classic.

Again

Many thanks

Andrew

 

[Pete_UK]

Glad you found it to be of use - thanks for feeding back.

Pete