![]() |
|
|||||||
|
|
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. |
|
|
Similar Threads
|
||||
| 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 |
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date
|
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 |
Using Field Codes to Calculate 5 years from a Date
|
vandy | Word | 1 | 09-23-2009 11:32 AM |