If the date is in cell A1:
=YEAR(TODAY())-YEAR(A1)+1
There are more elaborate alternatives than this (DATEDIF), but first try to
set this up, and then go for the alternatives if you want.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"GRANDIVA77" wrote:
I am creating a large spreadsheet. One colunm has dates(mm/dd/yyyy) I need to
create another column that refers to the date column which will produce a
certain amount of years.
Example.
The date column shows when an employee was hired.Say 05/02/1968. The next
column should show that he has worked for 40 years. Therefore I should see
the number 40 in the new column. How do I go about doing the function to get
this information show in the column? Please email me at
with any help you can give. I will be eternally greatful.