Spreadsheet: 739690d1625857028-multiple-if-conditions-based-on-multiple-criteria-promotionlist
Sheet: PAGE1

Pers.no. | Name Last Name | Beginning Date | End Date | Position | Explanatıon
310 | [NAME] | 2015-07-01 00:00:00 | 2015-10-31 00:00:00 | MANAGER
310 | [NAME] | 2015-11-01 00:00:00 | 2015-12-31 00:00:00 | MANAGER
310 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | MANAGER
310 | [NAME] | 2016-02-01 00:00:00 | 2017-07-31 00:00:00 | MANAGER
310 | [NAME] | 2017-08-01 00:00:00 | 2017-10-31 00:00:00 | MANAGER
310 | [NAME] | 2017-11-01 00:00:00 | 2018-12-31 00:00:00 | GROUP MANAGER | PROMOTION
310 | [NAME] | 2019-01-01 00:00:00 | 2020-11-30 00:00:00 | GROUP MANAGER
310 | [NAME] | 2020-12-01 00:00:00 | 2020-12-31 00:00:00 | GROUP MANAGER
310 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | GROUP MANAGER
313 | [NAME] | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-02-01 00:00:00 | 2016-03-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-04-01 00:00:00 | 2016-09-30 00:00:00 | SUPERVISOR | PROMOTION
313 | [NAME] | 2016-10-01 00:00:00 | 2017-01-31 00:00:00 | SUPERVISOR
313 | [NAME] | 2017-02-01 00:00:00 | 2017-06-30 00:00:00 | SUPERVISOR
313 | [NAME] | 2017-07-01 00:00:00 | 2020-12-31 00:00:00 | SUPERVISOR
313 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | SUPERVISOR
318 | PETE PACKETT | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2016-02-01 00:00:00 | 2017-01-31 00:00:00 | MANAGER | PROMOTION
318 | PETE PACKETT | 2017-02-01 00:00:00 | 2017-04-30 00:00:00 | MANAGER
318 | PETE PACKETT | 2017-05-01 00:00:00 | 2017-06-30 00:00:00 | MANAGER
318 | PETE PACKETT | 2017-07-01 00:00:00 | 2017-09-30 00:00:00 | MANAGER
318 | PETE PACKETT | 2017-10-01 00:00:00 | 2020-06-30 00:00:00 | MANAGER
318 | PETE PACKETT | 2020-07-01 00:00:00 | 9999-12-31 00:00:00 | DIRECTOR | PROMOTION
326 | LENA SMITH | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2016-01-01 00:00:00 | 2016-05-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2016-06-01 00:00:00 | 2017-07-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2017-08-01 00:00:00 | 2018-09-30 00:00:00 | DIRECTOR
326 | LENA SMITH | 2018-10-01 00:00:00 | 2018-10-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2018-11-01 00:00:00 | 2018-12-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2019-01-01 00:00:00 | 2020-12-31 00:00:00 | DIRECTOR
326 | LENA SMITH | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | DIRECTOR
328 | [NAME] | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | DIRECTOR
328 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST | DOWNGRADE
328 | [NAME] | 2016-02-01 00:00:00 | 2016-05-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2016-06-01 00:00:00 | 2017-01-31 00:00:00 | SPECIALIST
328 | [NAME] | 2017-02-01 00:00:00 | 2017-06-30 00:00:00 | SPECIALIST
328 | [NAME] | 2017-07-01 00:00:00 | 2017-12-31 00:00:00 | SPECIALIST
328 | [NAME] | 2018-01-01 00:00:00 | 2020-11-30 00:00:00 | ASSISTANT SPECIALIST | DOWNGRADE
328 | [NAME] | 2020-12-01 00:00:00 | 9999-12-31 00:00:00 | ASSISTANT SPECIALIST