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