Rounding UP Months' Difference between 2 dates

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

Bob Phillips

see other thread.

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ROUNDING UP monthly differences 7
Difference between dates returning full months and remaining days 5
I am attempting to find the difference between two dates... 2
difference between dates 2
Calculating time between mulitple dates 4
Difference between two dates 8
Months between two dates 5
Excel Microsoft excel interest formula 2

Top