View Single Post
  #1   Report Post  
Mary
 
Posts: n/a
Default DATEDIF calculates a month off

Suppose my start and end dates are in A1 & A2 respectively and I want
to count the number of months between them

A1: 09/01/04
A2: 01/31/05

=DATEDIF(A1,A2,"M") returns 4, instead of the correct count of 5.

What's up with that?

Anybody?

Thanks.
M&M