Datedif (FULL MONTH)

[wrightyrx7]

Hi all,

Trying to get a datedif formula to work.

a simple

=DATEDIF(A1,A2,"m")

if i put
A1 = 01/01/2012
A2 = 01/02/2012

This will return 1 month

if i put
A1 = 01/01/2012
A2 = 31/01/2012

This will return 0 months

For my purposes the 01/01/2012 and 31/01/2012 days are included. So all 31 days of January are accounted for. I would expect the formula to sat 1 month. Is there anything i can add to the formula to work the way i want it to?

Thanks in advance
Chris

[GreenDR]

DateAdd("m", -1, Now)

[Bob Phillips]

DateDif counts the difference in whole monthst, so two dates in Jan is no differnece. You could try

=DATEDIF(A1,A2+1,"M")

but be aware that DATEDIF has some nasty bugs.