Thank you. For some reason I am getting an anser of 1312. It seems like
excel is treating 11/1/2008 as if it is 11/1/1900...so it is telling me we
have 1312 months in between the two. Any idea?

"Rob" wrote:

Hello. I have a spreadsheet that has two cells -- Cell One is always today's
date using formula =Today(). The second cell is a date in the past. How can
I calculate the number of months that have passed (rounded up) from the past
date until today's date? I am hoping to see a number like "7" or "9" and not
days.

Thanks for your help!