![]() |
|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
![]()
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.
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula for looking at 1 cell with a date and then comparing it to four date ranges | LearningMom | Excel | 3 | 10-27-2017 12:44 PM |
![]() |
mshu31 | Word | 1 | 02-09-2017 02:04 PM |
Date range mysteriously adding 4 years | akatz85 | Excel | 7 | 03-25-2014 12:36 PM |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
![]() |
vandy | Word | 1 | 09-23-2009 11:32 AM |