Sorry Bob

But upon a starting date of Aug 31, 07 and ending date Sep. 1 2007, i.e. a
difference of only 1 day your offered formula returns the value "2" months.

"Bob Phillips" wrote:

=DATEDIF(A1-DAY(A1)+1,DATE(YEAR(A2),MONTH(A2)+1,1),"M")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"FARAZ QURESHI" wrote in message
...
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!