View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JT JT is offline
external usenet poster
 
Posts: 234
Default Calculate # of years

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!