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

T

Teri

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
 
T

Teri

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
Top