Spreadsheet: 729306d1619016405-conditional-formatting-that-involves-text-and-date-values-my-brain
Sheet: Programming

Identification |  |  | CBI-SA |  | TFAC |  | ART |  | AP |  | PR |  | EDU
Number | IDOC # | Name | Start | Complete | Start | Complete | Start | Complete | Start | Complete | Start | Complete | Class | Start | Complete
1 | 102380 | Aiken, Tiffany | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2020-12-15 00:00:00 | 2021-03-26 00:00:00 | N/A | N/A | N/A
2 | 83044 | [NAME], [NAME] | 2021-01-11 00:00:00 | 2021-06-02 00:00:00 | 2020-12-29 00:00:00 | 2021-04-01 00:00:00 | 2021-01-11 00:00:00 | 2021-03-26 00:00:00 | N/A | N/A | 2021-03-29 00:00:00 | 2021-04-22 00:00:00 | Parenting | 2021-01-18 00:00:00 | 2021-03-15 00:00:00
3 | 91484 | Barrientes, [NAME] | 2021-01-13 00:00:00 | 2021-06-07 00:00:00 | 2021-01-04 00:00:00 | 2021-04-07 00:00:00 | N/A | N/A | N/A | N/A | 2021-03-29 00:00:00 | 2021-04-22 00:00:00 | N/A | N/A | N/A
4 | 108403 | Broehl, Crystal | 2021-04-12 00:00:00 | 2021-09-01 00:00:00 | 2021-04-27 00:00:00 | 2021-07-29 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
5 | 125528 | Bullard, [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | X | X | X | X | GED | 2021-04-15 00:00:00 | 2022-04-15 00:00:00
6 | 137942 | Ferra, [NAME] | X | X | X | x | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
7 | 135590 | Fridell, [NAME] | 2020-12-01 00:00:00 | 2021-04-23 00:00:00 | 2020-12-04 00:00:00 | 2021-03-05 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
8 | 121088 | [NAME], [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | 2021-03-30 00:00:00 | 2021-06-29 00:00:00 | N/A | N/A | GED | 2021-03-15 00:00:00 | 2022-03-15 00:00:00
9 | 130576 | Garitone, [NAME] | X | X | X | X | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
10 | 69882 | Gittel, [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | 2021-04-06 00:00:00 | 2021-07-06 00:00:00 | N/A | N/A | N/A | N/A | N/A
11 | 63485 | Higgins, Rebecca | 2021-03-22 00:00:00 | 2021-08-11 00:00:00 | 2021-04-06 00:00:00 | 2021-07-08 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
12 | 135436 | Holbert, Tayler | X | X | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
13 | 122712 | Islas-Campos, Amelia | N/A | N/A | N/A | N/A | 2021-04-12 00:00:00 | 2021-06-25 00:00:00 | 2021-03-30 00:00:00 | 2021-06-29 00:00:00 | N/A | N/A | N/A | N/A | N/A
14 | 120135 | [NAME], Destini | N/A | N/A | 2021-04-06 00:00:00 | 2021-07-08 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
15 | 130526 | [NAME], Christine | 2020-11-30 00:00:00 | 2021-02-26 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
16 | 94200 | Mount, [NAME] | 2020-12-22 00:00:00 | 2021-05-13 00:00:00 | 2021-01-11 00:00:00 | 2021-04-15 00:00:00 | N/A | N/A | N/A | N/A | 2021-03-25 00:00:00 | 2021-04-25 00:00:00 | N/A | N/A | N/A
17 | 84934 | Royer, [NAME] | X | X | X | X | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
18 | 130117 | Rykowski, Emerald | N/A | N/A | N/A | N/A | N/A | N/A | X | X | N/A | N/A | N/A | N/A | N/A
19 | 135976 | [NAME], [NAME] | 2020-12-07 00:00:00 | 2021-04-28 00:00:00 | 2020-12-16 00:00:00 | 2021-03-18 00:00:00 | 2021-02-01 00:00:00 | 2021-04-08 00:00:00 | N/A | N/A | 2021-03-29 00:00:00 | 2021-04-22 00:00:00 | N/A | N/A | N/A
20 | 117784 | Vasquez, [NAME] | 2021-04-12 00:00:00 | 2021-08-10 00:00:00 | 2021-06-07 00:00:00 | 2021-08-11 00:00:00 | N/A | N/A | X | X | N/A | N/A | N/A | N/A | N/A
21 | 126284 | Vice, [NAME] | 2020-12-07 00:00:00 | 2021-04-21 00:00:00 | 2020-12-04 00:00:00 | 2021-03-05 00:00:00 | N/A | N/A | N/A | N/A | 2021-03-11 00:00:00 | 2021-03-26 00:00:00 | N/A | N/A | N/A
22 | 130984 | Walters, [NAME] | 2021-03-22 00:00:00 | 2021-08-11 00:00:00 | 2021-04-20 00:00:00 | 2021-07-23 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
23 | 133723 | [NAME] | N/A | N/A | N/A | N/A | N/A | N/A | 2021-04-06 00:00:00 | 2021-07-06 00:00:00 | N/A | N/A | N/A | N/A | N/A
24 | 137780 | Wood, Breanna | 2021-01-11 00:00:00 | 2021-06-02 00:00:00 | 2020-12-29 00:00:00 | 2021-04-01 00:00:00 | N/A | N/A | N/A | N/A | 2021-03-29 00:00:00 | 2021-04-22 00:00:00 | N/A | N/A | N/A
25 | 134318 | Wood, [NAME] | 2021-04-12 00:00:00 | 2021-08-10 00:00:00 | 2021-06-07 00:00:00 | 2021-08-11 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
26 | 136650 | [NAME], [NAME] | 2020-12-22 00:00:00 | 2021-05-13 00:00:00 | 2021-01-11 00:00:00 | 2021-04-15 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A