software

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

Hi Teri,

www.cpearson.com/excel/datedif.htm--
Kind regards,

Niek Otten

quot;Teriquot; gt; wrote in message
news
gt;I need a formula that looks at dates and calculates the number of full
gt;months
gt; from one date to the next. Can anyone help with this?
gt;
gt; Thanks -
gt; Teri
=DATEDIF(Date1,Date2,quot;mquot;)

Prerequisite: Date1 lt;= Date2

Teri wrote:
gt; I need a formula that looks at dates and calculates the number of full months
gt; from one date to the next. Can anyone help with this?
gt;
gt; Thanks -
gt; 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

quot;Niek Ottenquot; wrote:

gt; Hi Teri,
gt;
gt; www.cpearson.com/excel/datedif.htm
gt;
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Teriquot; gt; wrote in message
gt; news
gt; gt;I need a formula that looks at dates and calculates the number of full
gt; gt;months
gt; gt; from one date to the next. Can anyone help with this?
gt; gt;
gt; gt; Thanks -
gt; gt; Teri
gt;
gt;
gt;

Thank you - this is helpful.

Teri

quot;Aladin Akyurekquot; wrote:

gt; =DATEDIF(Date1,Date2,quot;mquot;)
gt;
gt; Prerequisite: Date1 lt;= Date2
gt;
gt; Teri wrote:
gt; gt; I need a formula that looks at dates and calculates the number of full months
gt; gt; from one date to the next. Can anyone help with this?
gt; gt;
gt; gt; Thanks -
gt; gt; Teri
gt;

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

gt;Thank you, this helps alot. It gets me closer to what I am trying to
gt;accomplish, however, it would be ideal if there were a formula that
gt;calculates only the full calendar months from one date to the next. I'm
gt;trying to create a vesting schedule based on full calendar months, do you
gt;know of another function that we be helpful?
gt;
gt;Thanks, again -
gt;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)),quot;mquot;)--ron