=DATEDIF(B1,A1,"y")
Where A1 is today,
And B1 is a past date.
Check out Chip Pearson's web page on this "Un-Documented" function:
(Except in XL2K)
http://www.cpearson.com/excel/datedif.htm
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"RAMON" wrote in message
...
I WANT TO CALCULATE THE #S OF YEARS BETWEEN TWO DATES