Spreadsheet: 683746d1592923916-conditional-formatting-on-date-not-working-correctly-forum-example-formatting
Sheet: Sheet1

Surname | First Name | Annual Date |  |  | Supervision 1 | Completed | Supervision 2 | Completed | Supervision 3 | Completed | Supv 4 & EOY
 |  | 2009-02-23 00:00:00 | Senior Support Worker |  | 2020-02-25 00:00:00 | Y
 |  | 2009-02-23 00:00:00 | Support Worker
 |  | 2009-02-23 00:00:00 | House Lead
 |  | 2009-02-23 00:00:00 | Night Support Worker
 |  | 2009-04-21 00:00:00 | Night Senior Support Worker
 |  | 2009-05-26 00:00:00 | Senior Support Worker
 |  | 2009-05-26 00:00:00 | Night Support Worker
 |  | 2009-07-07 00:00:00 | Senior support worker
 |  | 2009-08-03 00:00:00 | Support Worker
 |  | 2009-09-01 00:00:00 | Night Support Worker
 |  | 2010-01-18 00:00:00 | Senior Support Worker
 |  | 2010-01-18 00:00:00 | Senior Support Worker
 |  | 2010-01-21 00:00:00 | Night Support Worker
 |  | 2010-02-01 00:00:00 | House Lead
 |  | 2010-03-07 00:00:00 | Senior Support Worker
 |  | 2010-03-15 00:00:00 | Registered Nursing associate
 |  | 2010-05-10 00:00:00 | Registered nurse
 |  | 2010-05-10 00:00:00 | Registered nurse
 |  | 2010-05-10 00:00:00 | Senior Support Worker
 |  | 2010-06-19 00:00:00 | Support Worker
 |  | 2010-07-06 00:00:00 | Night Support Worker
 |  | 2010-07-08 00:00:00 | Support Worker
 |  | 2010-09-20 00:00:00 | Night Support Worker
 |  | 2010-09-20 00:00:00 | Night Support Worker
 |  | 2011-03-09 00:00:00 | Senior Support Worker
 |  | 2011-04-01 00:00:00 | [NAME]
 |  | 2011-10-01 00:00:00 | Senior Support Worker
 |  | 2011-11-28 00:00:00 | Senior support worker
 |  | 2012-04-01 00:00:00 | Support Worker
 |  | 2012-07-02 00:00:00 | Therapy Assistant
 |  | 2013-04-07 00:00:00 | Support Worker
 |  | 2013-04-07 00:00:00 | Night Support Worker
 |  | 2013-08-12 00:00:00 | Nights Support Worker
 |  | 2013-08-31 00:00:00 | House Lead
 |  | 2013-09-09 00:00:00 | Support Worker
 |  | 2013-10-13 00:00:00 | [NAME]
 |  | 2013-10-14 00:00:00 | Night Senior Support Worker
 |  | 2013-12-02 00:00:00 | Night Registered Nurse
 |  | 2014-01-13 00:00:00 | Support Worker
 |  | 2014-02-03 00:00:00 | Senior Support Worker
 |  | 2014-03-03 00:00:00 | Support Worker
 |  | 2014-03-03 00:00:00 | TNA
 |  | 2014-03-31 00:00:00 | Support Worker
 |  | 2014-04-01 00:00:00 | Support Worker
 |  | 2014-04-14 00:00:00 | Night Support Worker
 |  | 2014-04-28 00:00:00 | Support Worker
 |  | 2014-06-22 00:00:00 | Night Support Worker
 |  | 2014-08-04 00:00:00 | Support Worker
 |  | 2014-11-18 00:00:00 | Night Support Worker
 |  | 2015-01-16 00:00:00 | Night Support Worker
 |  | 2015-02-11 00:00:00 | Night Support Worker
 |  | 2015-03-01 00:00:00 | Senior Support Worker
 |  | 2015-03-03 00:00:00 | Support Worker
 |  | 2015-04-22 00:00:00 | Night Support Worker
 |  | 2015-05-01 00:00:00 | Support Worker
 |  | 2015-06-01 00:00:00 | Support Worker
 |  | 2015-06-01 00:00:00 | Support Worker
 |  | 2015-06-15 00:00:00 | Support Worker
 |  | 2015-09-14 00:00:00 | Support Worker
 |  | 2015-12-17 00:00:00 | Support Worker
 |  | 2016-01-04 00:00:00 | Night registered nurse
 |  | 2016-03-07 00:00:00 | Senior Support Worker
 |  | 2016-04-04 00:00:00 | House Lead
 |  | 2016-05-03 00:00:00 | Senior Support Worker
 |  | 2016-06-01 00:00:00 | Support Worker
 |  | 2016-06-06 00:00:00 | Support Worker
 |  | 2016-06-27 00:00:00 | Support Worker
 |  | 2016-06-27 00:00:00 | Support Worker
 |  | 2016-08-22 00:00:00 | Therapy Assistant
 |  | 2016-09-05 00:00:00 | [NAME]
 |  | 2016-09-19 00:00:00 | Support Worker
 |  | 2016-10-05 00:00:00 | Senoir Support Worker
 |  | 2016-10-17 00:00:00 | Night Support Worker
 |  | 2016-10-27 00:00:00 | Senior Support Worker
 |  | 2016-11-14 00:00:00 | Senior Support Worker
 |  | 2016-12-12 00:00:00 | Senior Support Worker
 |  | 2016-12-20 00:00:00 | Support Worker
 |  | 2017-01-03 00:00:00 | Support Worker
 |  | 2017-04-13 00:00:00 | Support Worker
 |  | 2017-05-19 00:00:00 | Senior Support Worker
 |  | 2017-05-23 00:00:00 | Support Worker
 |  | 2017-07-10 00:00:00 | Support Worker
 |  | 2017-08-15 00:00:00 | Senior Support Worker
 |  | 2017-08-29 00:00:00 | Support Worker
 |  | 2017-09-05 00:00:00 | Registered nurse
 |  | 2017-09-05 00:00:00 | Registered nurse
 |  | 2017-09-13 00:00:00 | Support Worker
 |  | 2017-10-02 00:00:00 | Night Support Worker
 |  | 2017-10-23 00:00:00 | Support Worker
 |  | 2017-11-01 00:00:00 | Nights Support Worker
 |  | 2017-11-17 00:00:00 | Night Support Worker
 |  | 2017-12-24 00:00:00 | Night Support Worker
 |  | 2018-01-29 00:00:00 | Support Worker
 |  | 2018-02-05 00:00:00 | Senior Support Worker
 |  | 2018-03-05 00:00:00 | Support Worker
 |  | 2018-04-19 00:00:00 | Support Worker
 |  | 2018-05-28 00:00:00 | Support Worker
 |  | 2018-06-06 00:00:00 | [NAME]
 |  | 2018-07-04 00:00:00 | Support Worker
 |  | 2018-07-23 00:00:00 | Support Worker
 |  | 2018-07-25 00:00:00 | Support Worker
 |  | 2018-09-12 00:00:00 | Support Worker
 |  | 2018-09-13 00:00:00 | Support Worker
 |  | 2018-10-10 00:00:00 | Support Worker
 |  | 2018-11-14 00:00:00 | Senior Support Worker
 |  | 2018-11-14 00:00:00 | Support Worker
 |  | 2018-11-16 00:00:00 | Support Worker
 |  | 2018-11-20 00:00:00 | Twilight Support Worker
 |  | 2018-11-25 00:00:00 | Support Worker
 |  | 2018-11-26 00:00:00 | Support Worker
 |  | 2018-11-29 00:00:00 | Night Support Worker
 |  | 2018-12-12 00:00:00 | Support Worker
 |  | 2019-01-16 00:00:00 | Support Worker
 |  | 2019-01-29 00:00:00 | TNA
 |  | 2019-03-25 00:00:00 | [NAME]
 |  | 2019-03-27 00:00:00 | Support Worker
 |  | 2019-04-11 00:00:00 | Support Worker
 |  | 2019-05-28 00:00:00 | Registered nurse
 |  | 2019-09-09 00:00:00 | Registered Nurse
 |  | 2019-09-18 00:00:00 | House Lead
 |  | 2019-11-17 00:00:00 | Night Registered Nurse
 |  | 2019-12-01 00:00:00 | Support Worker
 |  | 2019-12-10 00:00:00 | Support Worker
 |  | 2019-12-22 00:00:00 | Night Support Worker
 |  | 2020-01-13 00:00:00 | Night Support Worker