Hey Guys,

Simple solution I found myself!!!

=if(day(A1)=day(A2),datedif(a1,a2,"m"),datedif(a1, a2,"m")+1)

Thanx anyway for all your help!!!

"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!