Spreadsheet: 704839d1605773359-expiry-date-with-specific-criteria-formula-search-1-ans
Sheet: Disciplinaries_Data

Sequence | EMPLOYEE NR | ID# | Division | C/C | NAME | SURNAME | INCIDENT DATE | DATE REPORTED | DATE OF ACTION | DATE FINALISED | CATEGORY OF OFFENCE | TRANSGRESSION | OUTCOME | MONTH | [NAME] date | ACTIONED BY | LINE MANAGER | MY COMMENTS
001 |  |  |  |  |  |  |  |  | 2018-12-11 00:00:00 | 2019-01-08 00:00:00 | Substance Abuse | Under the influence | Final Written Warning
002 |  |  |  |  |  |  |  |  | 2018-12-11 00:00:00 | 2018-12-11 00:00:00 | Substance Abuse | Under the influence | Final Written Warning
003 |  |  |  |  |  |  |  |  | 2018-12-11 00:00:00 | 2018-12-18 00:00:00 | Negligence | Absconded | [NAME]
004 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2019-01-03 00:00:00 | Attendance | Reporting late for duty 03-12-2018 | 1st Level Warning
005 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-22 00:00:00 | Attendance | AWOL 03/12 & 04/12 | 2nd Level Warning
006 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2019-01-23 00:00:00 | Attendance | AWOL 3/12 & 04/12 | 2nd Level Warning
007 |  |  |  |  |  |  |  |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Attendance | Absconded | Absconded
008 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Attendance | AWOL 07/12/2018 | 2nd Level Warning
009 |  |  |  |  |  |  |  |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Attendance | Failure to report for OT on 08/12 as well as AWOL on the 10/12/2018 and failure to inform | Final Written Warning
010 |  |  |  |  |  |  |  |  | 2018-12-18 00:00:00 | 2018-12-21 00:00:00 | Attendance | AWOL 09/12/2018 | 2nd Level Warning
011 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Substance Abuse | Under the influence | Final Written Warning
012 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Attendance | Sleeping on duty | Final Written Warning
013 |  |  |  |  |  |  |  |  | 2018-12-29 00:00:00 | 2018-12-29 00:00:00 | Attendance | Absconded | Absconded
014 |  |  |  |  |  |  |  |  | 2018-12-18 00:00:00 | 2018-12-20 00:00:00 | Dishonesty | Theft - Milk | [NAME]
015 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Attendance | AWOL 15/12/2018 | 2nd Level Warning
016 |  |  |  |  |  |  |  |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Attendance | AWOL - 15-12-2018 | 2nd Level Warning
017 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2019-01-04 00:00:00 | Attendance | AWOL 16-24 Dec | [NAME]
018 |  |  |  |  |  |  |  |  | 2019-02-20 00:00:00 | 2018-12-20 00:00:00 | Attendance | AWOL 16/12/2018 | 2nd Level Warning
019 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Work Output | Poor work standards | Counselling
020 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Attendance | AWOL 16/12/2018 | 2nd Level Warning
021 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Work Output | Poor work standards | Counselling
022 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Work Output | Poor work standards | Counselling
023 |  |  |  |  |  |  |  |  | 2018-12-21 00:00:00 | 2018-12-21 00:00:00 | Work Output | Poor work standards | Counselling