=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
 

How does that work?

=DATEDIF(3/31/2006,5/31/2006,"m") = 2

How can I get Excel to count exactly one month between the dates 3/31/2006
and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.?

Dave


--
Brevity is the soul of wit.

=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
 

=DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m")

What you have is equivalent to

=DATEDIF(0.000048242369665198,0.000080403949441996 6,"m")

--
Regards,
Tom Ogilvy


"Dave F" wrote in message
...
How does that work?

=DATEDIF(3/31/2006,5/31/2006,"m") = 2

How can I get Excel to count exactly one month between the dates 3/31/2006
and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.?

Dave


--
Brevity is the soul of wit.

=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
 

Hi Dave

Slightly easier when dates are in cells
=DATEDIF(A1,B1,"m")+(DAY(A1)DAY(B1))

--
Regards

Roger Govier


"Dave F" wrote in message
...
How does that work?

=DATEDIF(3/31/2006,5/31/2006,"m") = 2

How can I get Excel to count exactly one month between the dates
3/31/2006
and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.?

Dave


--
Brevity is the soul of wit.

=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
 

=DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m")

No need for Datevalue:

=DATEDIF("3/31/2006","5/31/2006","m")

Biff

"Tom Ogilvy" wrote in message
...
=DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m")

What you have is equivalent to

=DATEDIF(0.000048242369665198,0.000080403949441996 6,"m")

--
Regards,
Tom Ogilvy


"Dave F" wrote in message
...
How does that work?

=DATEDIF(3/31/2006,5/31/2006,"m") = 2

How can I get Excel to count exactly one month between the dates
3/31/2006
and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.?

Dave


--
Brevity is the soul of wit.

=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
 

If someone said to me on March 31st "I'll see you in a months time." I would
not know for sure what they meant. Why should Excel be any different?


"Dave F" wrote in message
...
How does that work?

=DATEDIF(3/31/2006,5/31/2006,"m") = 2

How can I get Excel to count exactly one month between the dates 3/31/2006
and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.?

Dave


--
Brevity is the soul of wit.