Help please! Date formulas

J

Jennifer

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!
 
K

Kevin B

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

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