Spreadsheet: 801596d1666266851-formula-to-count-if-other-cells-dont-have-specific-info-quarterly-performance-formulas-needed
Sheet: Sheet1

 | WARNINGS |  |  |  |  |  |  |  |  |  | ABCs |  | ENFORCEMENT
Client | Stage 1 Date Served | Stage 1 Date Expires | Stage 1 Reminder Date Served | Stage 1 Reminder Date Expires | Stage 2 Date Served | Stage 2 Date Expires | Stage 2 Reminder Date Served | Stage 2 Reminder Date Expires | CPN warning date served | CPN warning date expiry | ABC Date Served | ABC Date Expires | CPN date served | CPN date expiry | Civil Injunction Date Served | Civil Injunction Date Expiry | CBO Date Served | CBO Date Expires | Premises Closure Date Served
038141FB |  |  |  |  | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 |  |  |  |  | 2016-05-03 00:00:00 | 2016-11-03 00:00:00 |  |  |  |  | 2018-05-14 00:00:00 | 2022-05-14 00:00:00 | 2021-12-29 00:00:00
7C8E0B82 | 2020-01-11 00:00:00 | 2020-04-11 00:00:00
31802488 |  |  |  |  | 2021-09-23 00:00:00 | 2021-12-23 00:00:00 |  |  | 2021-12-17 00:00:00 | 2022-03-17 00:00:00 | 2021-10-21 00:00:00 | 2022-04-21 00:00:00
8627D325 | 2022-01-19 00:00:00 | 2022-04-19 00:00:00
C326A265 | 2020-10-28 00:00:00 | 2021-01-28 00:00:00 | 2020-12-23 00:00:00 | 2021-03-23 00:00:00 | 2022-02-25 00:00:00 | 2022-05-25 00:00:00
538B0C34 | 2022-02-07 00:00:00 | 2022-05-07 00:00:00
E7A67DA0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-25 00:00:00 | 2024-01-25 00:00:00
19BF0E4F |  |  |  |  | 2020-04-02 00:00:00 | 2020-07-02 00:00:00
3C5554EE | 2019-04-10 00:00:00 | 2019-07-10 00:00:00 |  |  | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 |  |  |  |  | 2020-08-27 00:00:00 | 2020-02-27 00:00:00
ED769DC9 | 2022-05-15 00:00:00 | 2022-08-15 00:00:00
7E33FC41 | 2021-07-14 00:00:00 | 2021-10-14 00:00:00
C50D81FA | 2022-01-18 00:00:00 | 2022-04-18 00:00:00
82122E60 | 2022-04-28 00:00:00 | 2022-07-28 00:00:00
E24B3A61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-10-14 00:00:00 | 2020-10-14 00:00:00
CEB92BDE | 2015-03-21 00:00:00 | 2015-07-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2019-10-14 00:00:00 | 2020-10-14 00:00:00
Q2 Feedback (JUL22-SEPT22)
Warnings CPN Warnings & Reminders issued |  | Needs to simply count how many warnings and reminders were served between 01/06/2022 and [NAME] (columns B,D,F,H,J)
ABCs Issued |  | Needs to simply count how many ABCs and reminders were served between 01/06/2022 and [NAME] (column L)
Warnings & Reminders de-escalated |  | Needs to count how many warnings issued between 01/04/2022 and 30/06/2022 THAT DID NOT HAVE ANY WARNING OR ENFORCEMENT AFTER THE ISSUING DATE
ABCs de-escalated |  | Needs to count how many ABCs issued between 01/04/2022 and 30/06/2022 THAT DID NOT HAVE ANY WARNING OR ENFORCEMENT AFTER THE ISSUING DATE
CPN |  | Needs to simply count how many CPNs and reminders were served between 01/06/2022 and [NAME] (columns B,D,F,H,J)
Injunction |  | Needs to simply count how many INJUNCTIONS and reminders were served between 01/06/2022 and [NAME] (columns B,D,F,H,J)
CBO |  | Needs to simply count how many CBOs and reminders were served between 01/06/2022 and [NAME] (columns B,D,F,H,J)
Closure |  | Needs to simply count how many CLOSURES and reminders were served between 01/06/2022 and [NAME] (columns B,D,F,H,J)