View Single Post
 
Old 07-30-2018, 12:58 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Formula indicating employees entitled to a salary increase every three years from date of appointmen

There is an agency policy that every 3 years from the date of appointment or promotion, an employee is entitled to a percentage increase in his/her salary. If I use conditional formatting, what is the formula that will mark all employees that will receive increases during the year 2019? Say, Col A contains the names of all employees and column B contains the date of their appointment.
Reply With Quote