You're welcome.

For some reason known only to Mr Gates, DATEDIF() is the one function not
mentioned in Excel help.
--
David Biddulph

"Sarah" wrote in message
...
Thank you so much. You are amazing!

"David Biddulph" wrote:

=DATEDIF(A1,B1,"m")

"Sarah" wrote in message
...
Hi, I am trying to be able to calculate how many months are between two
dates. I have been able to figure it out for going from a month at the
beginning of the year to a month later in the year.

[ex. 2/12/07 to 9/1/07 gives me 7, with =MONTH(B2)-MONTH(C2)]

But if i were to go from 9/1/07 to 2/12/08, it won't work.

Can anyone help me?
-Sarah