Spreadsheet: 853426d1703274140-need-formula-to-show-a-current-department-for-employee-sample-dept-file
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | C75 | CHANGE | C76 | CHANGE | C77 | CHANGE | C78 | CHANGE
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $16.66 /$16.86 | 19.24 | TKC | 21.62 | TKC | 24 | TKC | 28.2 | TKC
 | Employee Name | Current Dept. |  |  |  |  |  |  |  |  |  |  |  | Raise Date at 70% Rate | 80% Rate | DEPART TO | 90% Rate | DEPART TO | 100% Rate | DEPART TO |  | DEPART TO
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2015-05-08 00:00:00 | 2016-05-08 00:00:00 | C75 | 2017-05-08 00:00:00 | C76 | 2018-05-08 00:00:00 | C77 | 2019-06-02 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2015-05-19 00:00:00 | 2016-05-19 00:00:00 | C75 | 2017-05-19 00:00:00 | C76 | 2018-05-19 00:00:00 | C77 | 2019-06-02 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-09 00:00:00 | 2016-07-09 00:00:00 | C75 | 2017-07-09 00:00:00 | C76 | 2018-07-09 00:00:00 | C77 | 2019-07-09 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2015-11-08 00:00:00 | 2016-11-08 00:00:00 | C75 | 2017-11-08 00:00:00 | C76 | 2018-11-08 00:00:00 | C77 | 2019-11-08 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2016-09-11 00:00:00 | 2017-09-11 00:00:00 | C75 | 2018-09-11 00:00:00 | C76 | 2019-09-11 00:00:00 | C77 | 2020-09-11 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2016-09-11 00:00:00 | 2017-09-11 00:00:00 | C75 | 2018-09-11 00:00:00 | C76 | 2019-09-11 00:00:00 | C77 | 2020-09-11 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-18 00:00:00 | 2017-12-18 00:00:00 | C75 | 2018-12-18 00:00:00 | C76 | 2019-12-18 00:00:00 | C77 | 2020-12-18 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2016-09-11 00:00:00 | 2017-09-11 00:00:00 | C75 | 2018-09-11 00:00:00 | C76 | 2019-09-11 00:00:00 | C77 | 2020-09-11 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2016-12-18 00:00:00 | 2017-12-18 00:00:00 | C75 | 2018-12-18 00:00:00 | C76 | 2019-12-18 00:00:00 | C77 | 2020-12-18 00:00:00 | C78
 | Smith, [NAME] 10 |  |  |  |  |  |  |  |  |  |  |  |  | 2019-09-01 00:00:00 | 2020-09-01 00:00:00 | C75 | 2021-09-01 00:00:00 | C76 | 2022-09-01 00:00:00 | C77 | 2023-09-01 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2020-01-06 00:00:00 | 2021-01-06 00:00:00 | C75 | 2022-01-06 00:00:00 | C76 | 2023-01-06 00:00:00 | C77 | 2024-01-06 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-30 00:00:00 | 2021-06-30 00:00:00 | C75 | 2022-06-30 00:00:00 | C76 | 2023-06-30 00:00:00 | C77 | 2024-06-30 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-26 00:00:00 | 2022-04-26 00:00:00 | C75 | 2023-04-26 00:00:00 | C76 | 2024-04-26 00:00:00 | C77 | 2025-04-26 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-24 00:00:00 | 2022-05-24 00:00:00 | C75 | 2023-05-24 00:00:00 | C76 | 2024-05-24 00:00:00 | C77 | 2025-05-24 00:00:00 | C78
 | Smith, [NAME] 15 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00 | 2022-06-01 00:00:00 | C75 | 2023-06-01 00:00:00 | C76 | 2024-06-01 00:00:00 | C77 | 2025-06-01 00:00:00 | C78
 | Smith, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-16 00:00:00 | 2022-09-16 00:00:00 | C75 | 2023-09-16 00:00:00 | C76 | 2024-09-16 00:00:00 | C77 | 2025-09-16 00:00:00 | C78