=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.