Employees anniversary dates

S

Steve j.

I am currently learning Excell. I have imported from our accounting software,
the employees past and present, along with all their general information.
(Address, salary, etc.) I was then able to sort them by seniority. I did a
year date function, but, if an employee started 4/1/1981, I had to add a
column that said 4/1/2005. (I am getting files ready for next year). It shows
the correct answer: 24.

My question is, instead of going back and changing all the employees to
2006, (when I am ready to update the files again), is their a code that
should go into the cell to automatically update the information that I am
looking for?

Any suggestions would be appreciated.
 
J

JulieD

Hi Steve
so you want a column showing the employee's seniority on the anniversary
date which falls within the current calendar year?

with the employee's start date in A2
=DATEDIF(A2,DATE(YEAR(NOW()),MONTH(A2),DAY(A2)),"y")

Cheers
JulieD
 
Top