Rounding UP Months' Difference between 2 dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
see other thread.

--
HTH

Bob

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