Spreadsheet: 714632d1611314102-conditional-formatting-error-on-certain-cells-in-range-book-1
Sheet: Formula Sheet

Meal relief times | Date W/C | x |  | x |  | Week Number
8:01:00 | 2019-12-30 00:00:00 | 1 |  | 1 |  | 40
0:45:00 | 2020-01-06 00:00:00 | 2 |  | 2 |  | 41
11:01:00 | 2020-01-13 00:00:00 | 1 |  | 3 |  | 42
1:00:00 | 2020-01-20 00:00:00 | 2 |  | 4 |  | 43
12:01:00 | 2020-01-27 00:00:00 | 1 |  | 5 |  | 44
1:15:00 | 2020-02-03 00:00:00 | 2 |  | 6 |  | 45
1:30:00 | 2020-02-10 00:00:00 | 1 |  | 7 |  | 46
4:00:00 | 2020-02-17 00:00:00 | 2 |  | 8 |  | 47
 | 2020-02-24 00:00:00 | 1 |  | 9 |  | 48
4:00:00 | 2020-03-02 00:00:00 | 2 |  | 10 |  | 49
6:00:00 | 2020-03-09 00:00:00 | 1 |  | 11 |  | 50
6:01:00 | 2020-03-16 00:00:00 | 2 |  | 12 |  | 51
6:45:00 | 2020-03-23 00:00:00 | 1 |  | 13 |  | 52
0:45:00 | 2020-03-30 00:00:00 | 2 |  | 14 |  | 1
 | 2020-04-06 00:00:00 | 1 |  | 15 |  | 2
 | 2020-04-13 00:00:00 | 2 |  | 16 |  | 3
 | 2020-04-20 00:00:00 | 1 |  | 17 |  | 4
 | 2020-04-27 00:00:00 | 2 |  | 18 |  | 5
 | 2020-05-04 00:00:00 | 1 |  | 19 |  | 6
 | 2020-05-11 00:00:00 | 2 |  | 20 |  | 7
 | 2020-05-18 00:00:00 | 1 |  | 21 |  | 8
 | 2020-05-25 00:00:00 | 2 |  | 22 |  | 9
 | 2020-06-01 00:00:00 | 1 |  | 23 |  | 10
 | 2020-06-08 00:00:00 | 2 |  | 24 |  | 11
 | 2020-06-15 00:00:00 | 1 |  | 25 |  | 12
 | 2020-06-22 00:00:00 | 2 |  | 26 |  | 13
 | 2020-06-29 00:00:00 | 1 |  | 27 |  | 14
 | 2020-07-06 00:00:00 | 2 |  | 28 |  | 15
 | 2020-07-13 00:00:00 | 1 |  | 29 |  | 16
 | 2020-07-20 00:00:00 | 2 |  | 30 |  | 17
 | 2020-07-27 00:00:00 | 1 |  | 31 |  | 18
 | 2020-08-03 00:00:00 | 2 |  | 32 |  | 19
 | 2020-08-10 00:00:00 | 1 |  | 33 |  | 20
 | 2020-08-17 00:00:00 | 2 |  | 34 |  | 21
 | 2020-08-24 00:00:00 | 1 |  | 35 |  | 22
 | 2020-08-31 00:00:00 | 2 |  | 36 |  | 23
 | 2020-09-07 00:00:00 | 1 |  | 37 |  | 24
 | 2020-09-14 00:00:00 | 2 |  | 38 |  | 25
 | 2020-09-21 00:00:00 | 1 |  | 39 |  | 26
 | 2020-09-28 00:00:00 | 2 |  | 40 |  | 27
 | 2020-10-05 00:00:00 | 1 |  | 41 |  | 28
 | 2020-10-12 00:00:00 | 2 |  | 42 |  | 29
 | 2020-10-19 00:00:00 | 1 |  | 43 |  | 30
 | 2020-10-26 00:00:00 | 2 |  | 44 |  | 31
 | 2020-11-02 00:00:00 | 1 |  | 45 |  | 32
 | 2020-11-09 00:00:00 | 2 |  | 46 |  | 33
 | 2020-11-16 00:00:00 | 1 |  | 47 |  | 34
 | 2020-11-23 00:00:00 | 2 |  | 48 |  | 35
 | 2020-11-30 00:00:00 | 1 |  | 49 |  | 36
 | 2020-12-07 00:00:00 | 2 |  | 50 |  | 37
 | 2020-12-14 00:00:00 | 1 |  | 51 |  | 38
 | 2020-12-21 00:00:00 | 2 |  | 52 |  | 39
 | 2020-12-28 00:00:00 | 1 |  | 1 |  | 40
 | 2021-01-04 00:00:00 | 2 |  | 2 |  | 41
 | 2021-01-11 00:00:00 | 1 |  | 2 |  | 42
 | 2021-01-18 00:00:00 | 2 |  | 3 |  | 43
 | 2021-01-25 00:00:00 | 1 |  | 4 |  | 44
 | 2021-02-01 00:00:00 | 2 |  | 5 |  | 45
 | 2021-02-08 00:00:00 | 1 |  | 6 |  | 46
 | 2021-02-15 00:00:00 | 2 |  | 7 |  | 47
 | 2021-02-22 00:00:00 | 1 |  | 8 |  | 48
 | 2021-03-01 00:00:00 | 2 |  | 9 |  | 49
 | 2021-03-08 00:00:00 | 1 |  | 10 |  | 50
 | 2021-03-15 00:00:00 | 2 |  | 11 |  | 51
 | 2021-03-22 00:00:00 | 1 |  | 12 |  | 52
 | 2021-03-29 00:00:00 | 2 |  | 13 |  | 1
 | 2021-04-05 00:00:00 | 1 |  | 14 |  | 2
 | 2021-04-12 00:00:00 | 2 |  | 15 |  | 3
 | 2021-04-19 00:00:00 | 1 |  | 16 |  | 4
 | 2021-04-26 00:00:00 | 2 |  | 17 |  | 5
 | 2021-05-03 00:00:00 | 1 |  | 18 |  | 6
 | 2021-05-10 00:00:00 | 2 |  | 19 |  | 7
 | 2021-05-17 00:00:00 | 1 |  | 20 |  | 8
 | 2021-05-24 00:00:00 | 2 |  | 21 |  | 9
 | 2021-05-31 00:00:00 | 1 |  | 22 |  | 10
 | 2021-06-07 00:00:00 | 2 |  | 23 |  | 11
 | 2021-06-14 00:00:00 | 1 |  | 24 |  | 12
 | 2021-06-21 00:00:00 | 2 |  | 25 |  | 13
 | 2021-06-28 00:00:00 | 1 |  | 26 |  | 14
 | 2021-07-05 00:00:00 | 2 |  | 27 |  | 15
 | 2021-07-12 00:00:00 | 1 |  | 28 |  | 16
 | 2021-07-19 00:00:00 | 2 |  | 29 |  | 17
 | 2021-07-26 00:00:00 | 1 |  | 30 |  | 18
 | 2021-08-02 00:00:00 | 2 |  | 31 |  | 19
 | 2021-08-09 00:00:00 | 1 |  | 32 |  | 20
 | 2021-08-16 00:00:00 | 2 |  | 33 |  | 21
 | 2021-08-23 00:00:00 | 1 |  | 34 |  | 22
 | 2021-08-30 00:00:00 | 2 |  | 35 |  | 23
 | 2021-09-06 00:00:00 | 1 |  | 36 |  | 24
 | 2021-09-13 00:00:00 | 2 |  | 37 |  | 25
 | 2021-09-20 00:00:00 | 1 |  | 38 |  | 26
 | 2021-09-27 00:00:00 | 2 |  | 39 |  | 27
 | 2021-10-04 00:00:00 | 1 |  | 40 |  | 28
 | 2021-10-11 00:00:00 | 2 |  | 41 |  | 29
 | 2021-10-18 00:00:00 | 1 |  | 42 |  | 30
 | 2021-10-25 00:00:00 | 2 |  | 43 |  | 31
 | 2021-11-01 00:00:00 | 1 |  | 44 |  | 32
 | 2021-11-08 00:00:00 | 2 |  | 45 |  | 33
 | 2021-11-15 00:00:00 | 1 |  | 46 |  | 34
 | 2021-11-22 00:00:00 | 2 |  | 47 |  | 35
 | 2021-11-29 00:00:00 | 1 |  | 48 |  | 36
 | 2021-12-06 00:00:00 | 2 |  | 49 |  | 37
 | 2021-12-13 00:00:00 | 1 |  | 50 |  | 38
 | 2021-12-20 00:00:00 | 2 |  | 51 |  | 39
 | 2021-12-27 00:00:00 | 1 |  | 52 |  | 40
 | 2022-01-03 00:00:00 | 2 |  | 1 |  | 41
 | 2022-01-10 00:00:00 | 1 |  | 2 |  | 42
 | 2022-01-17 00:00:00 | 2 |  | 3 |  | 43
 | 2022-01-24 00:00:00 | 1 |  | 4 |  | 44
 | 2022-01-31 00:00:00 | 2 |  | 5 |  | 45
 | 2022-02-07 00:00:00 | 1 |  | 6 |  | 46
 | 2022-02-14 00:00:00 | 2 |  | 7 |  | 47
 | 2022-02-21 00:00:00 | 1 |  | 8 |  | 48
 | 2022-02-28 00:00:00 | 2 |  | 9 |  | 49
 | 2022-03-07 00:00:00 | 1 |  | 10 |  | 50
 | 2022-03-14 00:00:00 | 2 |  | 11 |  | 51
 | 2022-03-21 00:00:00 | 1 |  | 12 |  | 52
 | 2022-03-28 00:00:00 | 2 |  | 13 |  | 1
 | 2022-04-04 00:00:00 | 1 |  | 14 |  | 2