Number of Months Between Two Dates Entered

[Rob]

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!

 

[Jacob Skaria]

Use DATEDIF function..
A1 = Start Date
B1 = End Date

=DATEDIF(A1,B1,"m")

If this post helps click Yes

 

[Rob]

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

 

[David Biddulph]

=DATEDIF(A1,TODAY(),"m")+(DATEDIF(A1,TODAY(),"md")>0)

 

[Jacob Skaria]

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

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

If this post helps click Yes

 

[Jacob Skaria]

=DATEDIF(A1,TODAY(),"M")

If this post helps click Yes

 

[Rob]

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]

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]

Did you try formatting the cell to the date format..

 

[David Biddulph]

The OP asked for rounded UP.
--
David Biddulph

=DATEDIF(A1,TODAY(),"M")

If this post helps click Yes

 

[David Biddulph]

The OP asked for rounded UP.
--
David Biddulph

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

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

If this post helps click Yes

 

[Pimamedic]

HOw are you entering the date?

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?

 

[David Biddulph]

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?

 

[PriceRK]

=ROUNDUP((b1-a1)/30,0)

HOw are you entering the date?