DATEDIF calculates a month off

M

Mary

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
 
J

JE McGimpsey

DATEDIF(...,"m") counts only whole months, presuming that days start at
midnight. So your span is only 4 months and 30 days long, not 5 months.

Of course, the whole concept of months is rather squirrelly. For
instance, one month after 1/30/05 - is it 2/28/05 (29 days), 3/1/05 (30
days)?, 3/2/05 (31 days)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
countifs Function not giving desired result with date criteria 2
Calculating time between mulitple dates 4
help with datedif function please 5
Summary of Difference between dates in years, months, days 4
Subtracting time...again 2
Datedif gives wrong result 2
Detailed Countdown 2

Top