I don't think we know much about Excel 2008. That is presumably a Mac
version?

If you format A1 temporarily as General, what number do you see? Should be
39753 if using 1900 date system. Macs normally default to the 1904 system,
but your results imply the 1900 system.

I assume that if you are struggling with Jacob's formula, you haven't tried
my version which rounds *up* as you requested?
--
David Biddulph

"Rob" wrote in message
...
Jacob,

Thank you so much for the reply. For some reason I am getting a number of
1311. Oddly, this is the number of months between 11/1/1900 and today.

My date range clearly reads 11/1/2008, my computer is XP and my excel is
excel 2008.

Do you have any ideas why my dates would be defaulting to 1900?

Thanks again for your reply.

"Jacob Skaria" wrote:

A1 = 11/1/2008
B1 = 4/20/2009

=DATEDIF(A1,B1,"M") will return 5

If this post helps click Yes
---------------
Jacob Skaria


"Rob" wrote:

Hello,

Thank you for the reply. I can't seem to get the formula to work
correctly.

Today's Date is 4/20/09
Start Date is 11/01/08

I was hoping to get the answer of 6 (for 6 months with April being
rounded
up).

Any ideas?

Thanks again for your help!

Best Regards,

Rob

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