Hello!
I am looking for a way to have Excel alert me to when an employee has reached an anniversary date, in intervals of 5, 10, 15, 20, 25.
I currently have excel set up to tell me Total Service Year by using the DATEIF function and a Calculation date in an adjacent cell.
Example: excel2.JPG
I'd like to see excel tell me based on a calculation date which employees have reached, say 5 years etc like so...
EXCEL.JPG
Is this possible?
Thank you in advance!
Bookmarks