Help please! Date formulas

[Guest]

Hey,

i have to find how long a stock has been held ((holding years)) i am giving
the date to calculate it from it is written as follows.

3/26/2005. What formula do i use to figure out the years its been since that
date.
thanks so much for your help!

 

[Guest]

Try this formula, changing the cell address A1 to the cell that contains your
date:

=TEXT(TODAY()-A1,"Y")

 

[Guest]

Thanks so much!