View Single Post
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

=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