On Tue, 5 Jul 2005 15:41:06 -0500, centerNegative
<centerNegative.1rpsyi_1120597519.9061@excelforu m-nospam.com wrote:


Here's what I got:

=DATEDIF(C35,C34,"m")&"m "&DATEDIF(C35,C34,"md")&"d"

Gives me: 1m 30d, which by my calcs, is correct.

I tried it again with 12/31/2004 - 10/16/2004 and it gave me 2m 16d.
Hope that helps.

Your formula does not take the times into account.

Also it (due to the way DATEDIF works) gives illogical results for certain
dates. For example:

C34: 01-Mar-2005 15:00
C35: 30-Jan-2005 07:00

I would think the "correct" answer would be:

1 month 1 day 08 h 00 min or
1 month 2 days 08 h 00 min

depending on how the OP wants to count "months".

Your formula gives the result:

1m -1d




--ron