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

[Guest]

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

 

[Tom Ogilvy]

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

What you have is equivalent to

=DATEDIF(0.000048242369665198,0.0000804039494419966,"m")

 

[Roger Govier]

Hi Dave

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

 

[Biff]

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

No need for Datevalue:

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

Biff

 

[David F Cox]

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?