Need help calculating months

[Guest]

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?

 

[Guest]

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



"Baldrick" skrev:

 

[Bob Phillips]

=datedif(start_date,end_date,"m")

--
HTH

Bob Phillips

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

 

[Guest]

Thanks, it working like a champ.

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



"Baldrick" skrev: