=DATEDIF(A1,TODAY(),"Y")
--
Gary''s Student - gsnu201001


"JT" wrote:

I need to be able to calculate the estimated age of a piece of equipment
beginning at it's construction date. For example:

Air Handler "A" was built in 2005. I need Cell C1 to tell me the number of
years since that date...and have the cell update each year into the future.

Help is greatly appreciated!