Date problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

@Homeonthecouch - 28 Jan 2007 00:28 GMT

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

Reply to this Message

Pete_UK - 28 Jan 2007 00:44 GMT

Hi Andrew,

Chip Pearson explains how to do this here:

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

Hope this helps.

Pete

> I am wanting to work out the time difference between two dates.
> Lets say 1/1/2000 to 10/4/2003
[quoted text clipped - 6 lines]
>
> Andrew

Reply to this Message

@Homeonthecouch - 28 Jan 2007 00:53 GMT

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

> Hi Andrew,
>
[quoted text clipped - 16 lines]
>>
>> Andrew

Reply to this Message

Pete_UK - 28 Jan 2007 01:32 GMT

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

Pete

> Many thanks that's a great help and I loved the "one of the drunk cousins of
> the Function Family" comment
[quoted text clipped - 26 lines]
>
> >> Andrew- Hide quoted text -- Show quoted text -

Reply to this Message

Gord Dibben - 28 Jan 2007 00:48 GMT

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

>I am wanting to work out the time difference between two dates.
>Lets say 1/1/2000 to 10/4/2003
[quoted text clipped - 6 lines]
>
>Andrew

Reply to this Message