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
 
G

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
 
Top