Number of Months Between Two Dates Entered
=ROUNDUP((b1-a1)/30,0)
"Pimamedic" wrote:
HOw are you entering the date?
"Rob" wrote:
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!
|