Spreadsheet: 777122d1650184097-count-no-of-cases-based-on-a-given-date-range-excelforum_countnocase-2
Sheet: Date

Date |  | DEC |  |  |  |  |  |  | Days | rows | shift
1 | 1 | 3 | 4 | 5 | 6 | 8 |  |  | 1
 | 9 | 10 | 11 | 12 | 13 | 15 |  |  | 2
 | 16 | 17 | 18 | 19 | 20 | 23 |  |  | 3
 | 24 | 25 | 26 | 27 | 28 | 29 |  |  | 4
 | 30 | 31 | 32 | 33 | 34 | 35 |  |  | 5
 | 37 | 38 | 39 | 40 | 42 | 43 |  |  | 6
2 | 1 | 3 | 4 | 5 | 6 | 9 |  |  | 7
 | 11 | 12 | 13 | 15 | 16 | 17 |  |  | 8
 | 18 | 19 | 20 | 22 | 23 | 24 |  |  | 9
 | 25 | 26 | 27 | 28 | 29 | 30 |  |  | 10
 | 31 | 32 | 33 | 35 | 36 | 37 |  |  | 11
 | 38 | 39 | 40 | 41 | 42 | 43 |  |  | 12
3 | 1 | 3 | 4 | 6 | 10 | 11 |  |  | 13
 | 13 | 14 | 16 | 17 | 18 | 19 |  |  | 14
 | 20 | 21 | 22 | 23 | 24 | 25 |  |  | 15
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 16
 | 32 | 33 | 34 | 35 | 36 | 37 |  |  | 17
 | 38 | 39 | 40 | 41 | 42 | 43 |  |  | 18
4 | 6 | 20 | 22 | 26 | 28 | 29 |  |  | 19
 | 31 | 33 | 35 | 37 | 38 | 40 |  |  | 20
 | 43 | x | x | x | x | x |  |  | 21
 |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | 23
 | SP | 23 | 41 | 42 |  |  |  |  | 24
5 | 6 | 8 | 13 | 17 | 22 | 29 |  |  | 25
 | 31 | 33 | 35 | 37 | 38 | 41 |  |  | 26
 | 43 | x | x | x | x | x |  |  | 27
 |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  | 29
 | SP | 23 | 28 | 12 |  |  |  |  | 30
6 | 6 | 8 | 9 | 10 | 11 | 12 |  |  | 31
 | 13 | 14 | 15 | 16 | 17 | 18
 | 19 | 20 | 21 | 22 | 23 | 24
 | 25 | 26 | 27 | 28 | 29 | 30
 | 31 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 39 | 40 | 41 | 43
7 | 1 | 3 | 4 | 6 | 8 | 9
 | 10 | 11 | 13 | 14 | 15 | 16
 | 17 | 18 | 19 | 21 | 22 | 23
 | 24 | 25 | 26 | 27 | 28 | 29
 | 30 | 31 | 32 | 33 | 34 | 35
 | 36 | 37 | 38 | 39 | 40 | 41
8 | 1 | 3 | 4 | 6 | 8 | 10
 | 11 | 12 | 13 | 14 | 15 | 16
 | 17 | 18 | 20 | 21 | 22 | 23
 | 24 | 26 | 27 | 28 | 29 | 30
 | 31 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 39 | 40 | 41 | 42
9 | 1 | 3 | 4 | 6 | 8 | 9
 | 10 | 11 | 12 | 14 | 15 | 16
 | 17 | 18 | 19 | 21 | 22 | 23
 | 24 | 26 | 27 | 28 | 29 | 30
 | 31 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 39 | 40 | 41 | 42
10 | 1 | 3 | 4 | 6 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 20 | 21
 | 22 | 23 | 24 | 26 | 29 | 30
 | 31 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 39 | 40 | 41 | 42
11 | 3 | 4 | 11 | 12 | 17 | 19
 | 22 | 31 | 34 | 35 | 38 | 39
 | 41 | X | X | X | X | X
 | SP | 24 | 29 | 37
12 | 1 | 9 | 11 | 16 | 17 | 19
 | 22 | 24 | 27 | 29 | 34 | 38
 | 42 | X | X | X | X | X
 | SP | 35 | 37 | 39
13 | 1 | 2 | 3 | 4 | 6 | 8
 | 9 | 10 | 11 | 12 | 13 | 14
 | 15 | 16 | 17 | 18 | 19 | 20
 | 21 | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 32 | 33 | 34
 | 35 | 36 | 37 | 38 | 40 | 41
14 | 1 | 2 | 3 | 4 | 6 | 8
 | 9 | 10 | 11 | 12 | 13 | 14
 | 15 | 16 | 17 | 18 | 19 | 21
 | 23 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 31 | 32 | 33 | 34
 | 35 | 36 | 37 | 38 | 40 | 41
15 | 1 | 2 | 4 | 6 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 20 | 21
 | 22 | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 32 | 33 | 34
 | 35 | 36 | 37 | 38 | 40 | 41
16 | 1 | 2 | 3 | 4 | 6 | 8
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 20 | 21
 | 22 | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 32 | 33 | 34 | 35
 | 36 | 37 | 38 | 39 | 40 | 41
17 | 1 | 2 | 3 | 4 | 6 | 8
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 21 | 22
 | 23 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 32 | 34 | 35 | 36
 | 37 | 38 | 39 | 40 | 41 | 43
18 | 2 | 3 | 16 | 18 | 22 | 25
 | 27 | 29 | 30 | 34 | 36 | 37
 | 38
 | SP | 35 | 40 | 41
19 | 2 | 6 | 12 | 16 | 18 | 27
 | 29 | 30 | 36 | 37 | 38 | 42
 | 43
 | SP | 22 | 23 | 41
20 | 2 | 3 | 4 | 6 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 20 | 21
 | 22 | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 32 | 33 | 35
 | 37 | 38 | 40 | 41 | 42 | 43
21 | 1 | 2 | 3 | 4 |  | 8
 | 9 | 10 | 11 | 12 | 13 | 15
 | 16 | 17 | 18 | 20 | 21 | 22
 | 23 | 24 | 26 | 27 | 28 | 29
 | 30 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 40 | 41 | 42 | 43
22 | 1 | 2 | 3 | 4 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 22 | 23
 | 24 | 25 | 26 | 27 | 28 | 29
 | 30 | 32 | 33 | 34 | 35 | 36
 | 37 | 38 | 40 | 41 | 42 | 43
23 | 2 | 3 | 4 | 6 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 21 | 22
 | 23 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 32 | 33 | 34 | 35
 | 36 | 37 | 40 | 41 | 42 | 43
24 | 1 | 2 | 3 | 4 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 21 | 22
 | 23 | 25 | 26 | 27 | 28 | 29
 | 30 | 31 | 33 | 34 | 35 | 36
 | 38 | 39 | 40 | 41 | 42 | 43
25 | 10 | 11 | 13 | 22 | 23 | 29
 | 33 | 34 | 37 | 38 | 40 | 41
 | 43
 | SP | 12 | 18 | 24
26 | 8 | 10 | 11 | 12 | 22 | 27
 | 29 | 33 | 34 | 35 | 37 | 38
 | 43
 | SP | 4 | 18 | 41
27 | 1 | 2 | 3 | 4 | 6 | 8
 | 9 | 10 | 11 | 12 | 13 | 14
 | 15 | 16 | 17 | 18 | 19 | 21
 | 22 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 34 | 35 | 36 | 37
 | 38 | 39 | 40 | 41 | 42 | 43
28 | 1 | 2 | 6 | 8 | 9 | 10
 | 11 | 12 | 13 | 14 | 15 | 16
 | 17 | 18 | 21 | 22 | 23 | 24
 | 25 | 26 | 27 | 28 | 29 | 30
 | 31 | 32 | 34 | 35 | 36 | 37
 | 38 | 39 | 40 | 41 | 42 | 43
29 | 1 | 2 | 3 | 6 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 20 | 21 | 23
 | 24 | 25 | 26 | 27 | 28 | 30
 | 31 | 32 | 34 | 35 | 36 | 37
 | 38 | 39 | 40 | 41 | 42 | 43
30 | 1 | 2 | 3 | 4 | 8 | 9
 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 20 | 21 | 23
 | 25 | 26 | 27 | 28 | 30 | 31
 | 32 | 33 | 34 | 35 | 36 | 37
 | 38 | 39 | 40 | 41 | 42 | 43
31 | 1 | 2 | 3 | 4 | 8 | 9
 | 10 | 11 | 13 | 14 | 15 | 16
 | 17 | 18 | 20 | 21 | 23 | 24
 | 25 | 26 | 27 | 28 | 29 | 30
 | 32 | 33 | 34 | 35 | 36 | 37
 | 38 | 39 | 40 | 41 | 42 | 43