Help please! Date formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Try this formula, changing the cell address A1 to the cell that contains your
date:

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