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.

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.

If your dates are in Col A then enter this in B1 and copy down...
=DATEDIF(A2,NOW(),"y")

This will give completed years

"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.