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?
|