Spreadsheet: 812328d1673073242-countif-dates-with-countblank-formula-logic-for-cases-1-6-2023
Sheet: Logic

Case Cd | Case Type Id | Opened Date | Closed Dt | Reported Dt | Case Status Flag | Universal Date
2 | ER | 2019-01-03 00:00:00 |  | 2018-12-19 00:00:00 | Open | 2018-12-19 00:00:00
8 | ER | 2021-03-03 00:00:00 | 2021-10-12 00:00:00 | 2021-02-16 00:00:00 | Open | 2021-02-16 00:00:00
7 | EEO | 2021-04-04 00:00:00 | 2021-11-21 00:00:00 | 2021-03-20 00:00:00 | Open | 2021-03-20 00:00:00
16 | ER | 2021-10-01 00:00:00 | 2021-12-01 00:00:00 | 2021-09-16 00:00:00 | Open | 2021-09-16 00:00:00
20 | Litigation | 2021-10-29 00:00:00 |  | 2021-10-14 00:00:00 | Open | 2021-10-14 00:00:00
21 | ER | 2021-10-30 00:00:00 | 2022-02-01 00:00:00 | 2021-10-15 00:00:00 | Open | 2021-10-15 00:00:00
15 | ER | 2021-11-01 00:00:00 | 2021-11-30 00:00:00 | 2021-10-17 00:00:00 | Open | 2021-10-17 00:00:00
22 | ER | 2021-11-05 00:00:00 |  | 2021-10-21 00:00:00 | Open | 2021-10-21 00:00:00
12 | Litigation | 2022-01-01 00:00:00 | 2022-11-01 00:00:00 | 2021-12-17 00:00:00 | Open | 2021-12-17 00:00:00
18 | EEO | 2022-04-04 00:00:00 | 2022-06-04 00:00:00 | 2022-03-20 00:00:00 | Open | 2022-03-20 00:00:00
17 | EEO | 2022-09-09 00:00:00 | 2022-12-15 00:00:00 | 2022-08-25 00:00:00 | Open | 2022-08-25 00:00:00
14 | ER | 2022-10-01 00:00:00 |  | 2022-09-16 00:00:00 | Open | 2022-09-16 00:00:00
19 | EEO | 2022-10-28 00:00:00 |  | 2022-10-13 00:00:00 | Open | 2022-10-13 00:00:00
13 | ER | 2022-11-01 00:00:00 | 2022-11-30 00:00:00 | 2022-10-17 00:00:00 | Open | 2022-10-17 00:00:00
 | TF1 |  | 3/1/2021 - 11/1/2021
 | ACTIVE CASES |  | NEW | CLOSED |  |  | UNRESOLVED
 | 8 |  | 6 | 1 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | ACTIVE CASES
Case Cd | Case Type Id | Opened Date | Closed Dt | Reported Dt |  |  | Case Status Flag |  | Any cases still open til end TF 2 | 5 |  | TF 2
2 | ER | 2019-01-03 00:00:00 |  | 2018-12-19 00:00:00 |  |  | Open | +plus | Closed dt between TF 2 | 3 |  | Filter range:
8 | ER | 2021-03-03 00:00:00 | 2021-10-12 00:00:00 | 2021-02-16 00:00:00 |  |  | Closed | +plus | Reported Dt between TF 2 | 2 |  | Start Date | 2022-01-01 00:00:00
7 | EEO | 2021-04-04 00:00:00 | 2021-11-21 00:00:00 | 2021-03-20 00:00:00 |  |  | Closed |  | Active Cases |  |  | End Date | 2022-11-01 00:00:00
16 | ER | 2021-10-01 00:00:00 | 2021-12-01 00:00:00 | 2021-09-16 00:00:00 |  |  | Closed |  |  |  |  | Any cases still open til end TF 2 (11/1/2022). NO CLOSED DT until 11/1/2022 | ???
20 | Litigation | 2021-10-29 00:00:00 |  | 2021-10-14 00:00:00 |  |  | Open
21 | ER | 2021-10-30 00:00:00 | 2022-02-01 00:00:00 | 2021-10-15 00:00:00 |  |  | Closed |  |  |  |  | PLUS '+'
15 | ER | 2021-11-01 00:00:00 | 2021-11-30 00:00:00 | 2021-10-17 00:00:00 |  |  | Closed |  |  |  |  | Any cases that have Closed dt between 1/1/2022-11/1/2022
22 | ER | 2021-11-05 00:00:00 |  | 2021-10-21 00:00:00 |  |  | Open
12 | Litigation | 2022-01-01 00:00:00 | 2022-11-01 00:00:00 | 2021-12-17 00:00:00 |  |  | Closed |  |  |  |  | PLUS '+'
18 | EEO | 2022-04-04 00:00:00 | 2022-06-04 00:00:00 | 2022-03-20 00:00:00 |  |  | Closed |  |  |  |  | Any cases that have Reported Dt between TF 2
17 | EEO | 2022-09-09 00:00:00 | 2022-12-15 00:00:00 | 2022-08-25 00:00:00 |  |  | Closed |  |  |  |  | EXPECTED RESULT IF I SELECT 1/1/2022 to 11/1/2022
14 | ER | 2022-10-01 00:00:00 |  | 2022-09-16 00:00:00 |  |  | Open
19 | EEO | 2022-10-28 00:00:00 |  | 2022-10-13 00:00:00 |  |  | Open
13 | ER | 2022-11-01 00:00:00 | 2022-11-30 00:00:00 | 2022-10-17 00:00:00 |  |  | Closed |  |  |  |  | NEW CASES
 |  |  |  |  |  |  |  |  |  |  |  | TF 2
 |  |  |  |  |  |  |  |  |  |  |  | Filter range:
 |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2022-01-01 00:00:00
 | TF2 |  | 1/1/2022 - 11/1/2022 |  |  |  |  |  |  |  |  | End Date | 2022-11-01 00:00:00
 | ACTIVE CASES |  | NEW | CLOSED |  |  | UNRESOLVED |  |  |  |  | Any cases with a reported date between 1/1/2022-11/1/2022
 | 10 |  | 5 | 3 |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | CLOSED CASES
 |  |  |  |  |  |  |  |  |  |  |  | TF 2
 |  |  |  |  |  |  |  |  |  |  |  | Filter range:
 |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | End Date | 2022-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Any cases with a closed date between 1/1/2022-11/1/2022
 |  |  |  |  |  |  |  |  |  |  |  | UNRESOLVED CASES
 |  |  |  |  |  |  |  |  |  |  |  | TF 2
 |  |  |  |  |  |  |  |  |  |  |  | Filter range:
 |  |  |  |  |  |  |  |  |  |  |  | Start Date | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | End Date | 2022-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Total Count cases during 3/1/2021 to 11/1/2021
 |  |  |  |  |  |  |  |  |  |  |  | PLUS '+'
 |  |  |  |  |  |  |  |  |  |  |  | Total Count open cases before 1/1/2022. 1/1/2022 IS EXCLUDED
 |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT IF I SELECT 1/1/2022 to 11/1/2022