What is the formula for calculating the number of months passed?
 

I need a formula that looks at dates and calculates the number of full months
from one date to the next. Can anyone help with this?

Thanks -
Teri

What is the formula for calculating the number of months passed?
 

Hi Teri,

http://www.cpearson.com/excel/datedif.htm


--
Kind regards,

Niek Otten

"Teri" wrote in message
...
I need a formula that looks at dates and calculates the number of full
months
from one date to the next. Can anyone help with this?

Thanks -
Teri

What is the formula for calculating the number of months passed?
 

=DATEDIF(Date1,Date2,"m")

Prerequisite: Date1 <= Date2

Teri wrote:
I need a formula that looks at dates and calculates the number of full months
from one date to the next. Can anyone help with this?

Thanks -
Teri

What is the formula for calculating the number of months passe
 

Thank you, this helps alot. It gets me closer to what I am trying to
accomplish, however, it would be ideal if there were a formula that
calculates only the full calendar months from one date to the next. I'm
trying to create a vesting schedule based on full calendar months, do you
know of another function that we be helpful?

Thanks, again -
Teri

"Niek Otten" wrote:

Hi Teri,

http://www.cpearson.com/excel/datedif.htm


--
Kind regards,

Niek Otten

"Teri" wrote in message
...
I need a formula that looks at dates and calculates the number of full
months
from one date to the next. Can anyone help with this?

Thanks -
Teri

What is the formula for calculating the number of months passe
 

Thank you - this is helpful.

Teri

"Aladin Akyurek" wrote:

=DATEDIF(Date1,Date2,"m")

Prerequisite: Date1 <= Date2

Teri wrote:
I need a formula that looks at dates and calculates the number of full months
from one date to the next. Can anyone help with this?

Thanks -
Teri

What is the formula for calculating the number of months passe
 

On Wed, 8 Mar 2006 13:49:27 -0800, Teri wrote:

Thank you, this helps alot. It gets me closer to what I am trying to
accomplish, however, it would be ideal if there were a formula that
calculates only the full calendar months from one date to the next. I'm
trying to create a vesting schedule based on full calendar months, do you
know of another function that we be helpful?

Thanks, again -
Teri

With your earlier date in A1, and your later date in A2, this formula should
give you what you describe:

=DATEDIF(IF(DAY(A1)=1,A1,A1-DAY(A1)+
33-DAY(A1-DAY(A1)+32)),IF(DAY(A2)=1,
A2,A2+1-DAY(A2)),"m")


--ron