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.