Need help calculating months
 

I have 1 colum of dates, in another i would like the number of months between
today and that date, either positve or negitive. However "=month(x)-month(y)"
doesnt recongnize a difference in years. For example 4/17/07 - 7/10/06
returns -3 instead of +9. My dates vary from over a year ago to over a year
from now. Does anyone know of a possible solution?

Need help calculating months
 

=(YEAR(NOW())-YEAR(A2))*12+(MONTH(NOW())-MONTH(A2))



"Baldrick" skrev:

I have 1 colum of dates, in another i would like the number of months between
today and that date, either positve or negitive. However "=month(x)-month(y)"
doesnt recongnize a difference in years. For example 4/17/07 - 7/10/06
returns -3 instead of +9. My dates vary from over a year ago to over a year
from now. Does anyone know of a possible solution?

Need help calculating months
 

=datedif(start_date,end_date,"m")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Baldrick" wrote in message
...
I have 1 colum of dates, in another i would like the number of months
between
today and that date, either positve or negitive. However
"=month(x)-month(y)"
doesnt recongnize a difference in years. For example 4/17/07 - 7/10/06
returns -3 instead of +9. My dates vary from over a year ago to over a
year
from now. Does anyone know of a possible solution?

Need help calculating months
 

Thanks, it working like a champ.

"excelent" wrote:

=(YEAR(NOW())-YEAR(A2))*12+(MONTH(NOW())-MONTH(A2))



"Baldrick" skrev:

I have 1 colum of dates, in another i would like the number of months between
today and that date, either positve or negitive. However "=month(x)-month(y)"
doesnt recongnize a difference in years. For example 4/17/07 - 7/10/06
returns -3 instead of +9. My dates vary from over a year ago to over a year
from now. Does anyone know of a possible solution?