Full months and DATEDIF

[tedcahill2]

I generally use DATEDIF to determine number of months between two dates, and it works 99% of the time.

I have an instance where I want to write a function to count months, but if I were to use 01/01/2018 and 01/31/2018 DATEDIF I need something that would recognize that as a full month. Like start of date 01/01 to end of day 01/31 should be 1 month.

[63falcondude]

Maybe something like this?

=DATEDIF(A1,B1+--(B1=EOMONTH(A1,0)),"m")

Where A1 = start date and B1 = end date.

[xlnitwit]

Any reason you can't just add 1 to the second date?