Sorry Mike

Upon a starting date of Aug 01, 07 I was expecting your formula to be
returning a result of 1 upon the ending date being set at even Aug 02, 07 and
similarly a result of 2 upon ending date of Sep. 2, 2007, i.e. a difference
of 1 month and a 1 day being rounded up.

However, upon even dates like (beg.) Aug 01, 2007 and (end.) Sept. 30 a
difference of only 1 month is being returned by your formula instead of 2.

"Mike H" wrote:

=MAX(DATEDIF(A1,EOMONTH(B1,0),"m"),1)

"FARAZ QURESHI" wrote

Hi every1

I want to calculate the number of months between two dates.

Datedif() may be used but upon a difference of less than 15 days it rounds
off the balance to 0 months.

I want to Round Up the difference upon a fractional month i.e. even 1 day
difference returns a 1 month difference and 13 months and 1 day to be showing
14 months!

All assistance shall highly be obliged!