I need to create a conditional format that calculates from the employee start date to their anniversary.
each year i need a reminder when the employee's anniversary date is coming up because they get a salary increase each year.
i have looked over the forrum and i am having trouble finding a format that will predict future dates.
Please help, this is my last desperate attempt to work this out.
I have attached a trial of what i am working with. i would love if i could please have some guideance to get the start date to flag red when the anniversay date is due.
Many thanks in advance.
Bookmarks