Help please! Date formulas
 

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!

Help please! Date formulas
 

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

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


"Jennifer" wrote:

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!

Help please! Date formulas
 

Thanks so much!