Spreadsheet: 689549d1596505938-creating-monthly-average-from-weekly-data-with-date-as-string-weekly2monthly-v1-
Sheet: Sheet1 (2)

Week of the year | year | Volume | Average unit value | start of he week | month
1 | 2016 | 298 | 4.19
2 | 2016 | 296 | 4.39
3 | 2016 | 285 | 4.64
4 | 2016 | 266 | 4.29
5 | 2016 | 288 | 4.57
6 | 2016 | 343 | 4.49
 |  |  |  |  | Jan-2016 Average
7 | 2016 | 277 | 4.69
8 | 2016 | 218 | 4.72
9 | 2016 | 212 | 4.86
10 | 2016 | 331 | 4.84
 |  |  |  |  | Feb-2016 Average
11 | 2016 | 309 | 4.88
12 | 2016 | 77 | 5.91
13 | 2016 | 116 | 5.16
14 | 2016 | 214 | 5.26
 |  |  |  |  | Mar-2016 Average
15 | 2016 | 239 | 5.7
16 | 2016 | 202 | 5.5
17 | 2016 | 304 | 5.36
18 | 2016 | 117 | 5.58
 |  |  |  |  | [NAME]
19 | 2016 | 151 | 6.02
20 | 2016 | 114 | 6.14
21 | 2016 | 181 | 5.98
22 | 2016 | 233 | 5.81
23 | 2016 | 217 | 5.99
 |  |  |  |  | May-2016 Average
24 | 2016 | 216 | 6.34
25 | 2016 | 343 | 6.02
26 | 2016 | 273 | 6.06
27 | 2016 | 241 | 6.74
 |  |  |  |  | [NAME]
28 | 2016 | 225 | 6.83
29 | 2016 | 284 | 6.57
30 | 2016 | 321 | 6.31
31 | 2016 | 362 | 5.89
32 | 2016 | 296 | 6.22
 |  |  |  |  | Jul-2016 Average
33 | 2016 | 288 | 5.62
34 | 2016 | 448 | 4.99
35 | 2016 | 219 | 5.24
36 | 2016 | 228 | 5.27
 |  |  |  |  | Aug-2016 Average
37 | 2016 | 454 | 5.22
38 | 2016 | 294 | 5.16
39 | 2016 | 111 | 5.39
40 | 2016 | 135 | 6.22
 |  |  |  |  | Sep-2016 Average
41 | 2016 | 110 | 6.29
42 | 2016 | 195 | 6.52
43 | 2016 | 102 | 7.06
44 | 2016 | 86 | 7.13
45 | 2016 | 107 | 6.9
 |  |  |  |  | Oct-2016 Average
46 | 2016 | 172 | 7.03
47 | 2016 | 129 | 7.24
48 | 2016 | 171 | 7.42
49 | 2016 | 264 | 7.43
 |  |  |  |  | Nov-2016 Average
50 | 2016 | 136 | 7.88
51 | 2016 | 132 | 7.42
52 | 2016 | 103 | 7.73
 |  |  |  |  | Dec-2016 Average
1 | 2017 | 196 | 7.69
2 | 2017 | 135 | 6.89
3 | 2017 | 85 | 7.67
4 | 2017 | 93 | 7.56
5 | 2017 | 92 | 7.58
 |  |  |  |  | Jan-2017 Average
6 | 2017 | 80 | 7.37
7 | 2017 | 50 | 7.99
8 | 2017 | 166 | 7.73
9 | 2017 | 203 | 7.72
 |  |  |  |  | Feb-2017 Average
10 | 2017 | 210 | 7.78
11 | 2017 | 229 | 7.79
12 | 2017 | 206 | 8.03
13 | 2017 | 225 | 7.88
 |  |  |  |  | Mar-2017 Average
14 | 2017 | 93 | 8.05
15 | 2017 | 64 | 8.07
16 | 2017 | 78 | 8.21
17 | 2017 | 42 | 8.09
18 | 2017 | 83 | 8.19
 |  |  |  |  | Apr-2017 Average
19 | 2017 | 71 | 8.22
20 | 2017 | 59 | 8.56
21 | 2017 | 72 | 8.22
22 | 2017 | 74 | 8.43
 |  |  |  |  | May-2017 Average
23 | 2017 | 74 | 8.1
24 | 2017 | 43 | 8.18
25 | 2017 | 57 | 7.52
26 | 2017 | 83 | 8
 |  |  |  |  | Jun-2017 Average
27 | 2017 | 55 | 7.89
28 | 2017 | 57 | 7.77
29 | 2017 | 47 | 7.89
30 | 2017 | 105 | 7.89
31 | 2017 | 93 | 7.56
 |  |  |  |  | Jul-2017 Average
32 | 2017 | 250 | 7.49
33 | 2017 | 237 | 6.49
34 | 2017 | 160 | 6.14
35 | 2017 | 214 | 6.33
 |  |  |  |  | Aug-2017 Average
36 | 2017 | 182 | 6.04
37 | 2017 | 204 | 5.65
38 | 2017 | 278 | 5.78
39 | 2017 | 121 | 5.82
 |  |  |  |  | Sep-2017 Average
40 | 2017 | 155 | 5.82
41 | 2017 | 134 | 5.93
42 | 2017 | 116 | 5.57
43 | 2017 | 105 | 5.41
44 | 2017 | 175 | 5.3
 |  |  |  |  | Oct-2017 Average
45 | 2017 | 109 | 5.39
46 | 2017 | 146 | 5.24
47 | 2017 | 173 | 5.14
48 | 2017 | 186 | 4.89
 |  |  |  |  | Nov-2017 Average
49 | 2017 | 213 | 5.02
50 | 2017 | 90 | 5.61
51 | 2017 | 110 | 5.27
52 | 2017 | 74 | 5.44
 |  |  |  |  | Dec-2017 Average
1 | 2018 | 62 | 5.8
2 | 2018 | 165 | 5.46
3 | 2018 | 159 | 5.6
4 | 2018 | 121 | 5.75
5 | 2018 | 117 | 6.14
 |  |  |  |  | Jan-2018 Average
6 | 2018 | 156 | 5.77
7 | 2018 | 192 | 5.77
8 | 2018 | 136 | 5.98
9 | 2018 | 83 | 6.18
 |  |  |  |  | Feb-2018 Average
10 | 2018 | 89 | 6.61
11 | 2018 | 202 | 5.81
12 | 2018 | 210 | 6.26
13 | 2018 | 91 | 5.85
 |  |  |  |  | Mar-2018 Average
14 | 2018 | 91 | 5.94
15 | 2018 | 108 | 6.12
16 | 2018 | 107 | 6.34
17 | 2018 | 96 | 6.2
18 | 2018 | 128 | 6.45
 |  |  |  |  | Apr-2018 Average
19 | 2018 | 127 | 6.53
20 | 2018 | 91 | 6.74
21 | 2018 | 150 | 6.32
22 | 2018 | 118 | 5.94
 |  |  |  |  | May-2018 Average
23 | 2018 | 88 | 6.12
24 | 2018 | 85 | 5.82
25 | 2018 | 89 | 6.69
26 | 2018 | 112 | 6.29
 |  |  |  |  | Jun-2018 Average
27 | 2018 | 66 | 6.12
28 | 2018 | 154 | 5.72
29 | 2018 | 178 | 5.53
30 | 2018 | 216 | 4.99
31 | 2018 | 178 | 4.56
 |  |  |  |  | Jul-2018 Average
32 | 2018 | 119 | 4.74
33 | 2018 | 106 | 5.39
34 | 2018 | 42 | 5.5
35 | 2018 | 93 | 5.6
 |  |  |  |  | Aug-2018 Average
36 | 2018 | 70 | 6.17
37 | 2018 | 131 | 5.45
38 | 2018 | 315 | 5.43
39 | 2018 | 287 | 5.26
40 | 2018 | 253 | 5.21
 |  |  |  |  | Sep-2018 Average
41 | 2018 | 223 | 5.29
42 | 2018 | 236 | 5.29
43 | 2018 | 218 | 5.32
44 | 2018 | 176 | 5.36
 |  |  |  |  | Oct-2018 Average
45 | 2018 | 280 | 5.2
46 | 2018 | 265 | 4.93
47 | 2018 | 234 | 4.67
48 | 2018 | 273 | 4.68
 |  |  |  |  | Nov-2018 Average
49 | 2018 | 158 | 4.89
50 | 2018 | 359 | 4.43
51 | 2018 | 225 | 4.5
52 | 2018 | 50 | 5.25
 |  |  |  |  | Dec-2018 Average
1 | 2019 | 53 | 6
2 | 2019 | 106 | 5.71
3 | 2019 | 63 | 6.04
4 | 2019 | 187 | 5.83
5 | 2019 | 167 | 5.77
 |  |  |  |  | [NAME]
6 | 2019 | 79 | 5.85
7 | 2019 | 92 | 5.92
8 | 2019 | 127 | 6.06
9 | 2019 | 80 | 6.1
 |  |  |  |  | Feb-2019 Average
10 | 2019 | 52 | 6.91
11 | 2019 | 91 | 7.1
12 | 2019 | 61 | 6.93
13 | 2019 | 120 | 6.47
14 | 2019 | 81 | 6.8
 |  |  |  |  | Mar-2019 Average
15 | 2019 | 131 | 5.8
16 | 2019 | 67 | 6.11
17 | 2019 | 152 | 6.12
18 | 2019 | 114 | 5.3
 |  |  |  |  | Apr-2019 Average
19 | 2019 | 103 | 5.36
20 | 2019 | 123 | 5.12
21 | 2019 | 155 | 5.06
22 | 2019 | 154 | 5.14
 |  |  |  |  | May-2019 Average
23 | 2019 | 102 | 5.15
24 | 2019 | 170 | 5.39
25 | 2019 | 182 | 5.15
26 | 2019 | 140 | 5.25
27 | 2019 | 171 | 4.96
 |  |  |  |  | [NAME]
28 | 2019 | 118 | 5.14
29 | 2019 | 164 | 4.8
30 | 2019 | 250 | 4.85
31 | 2019 | 162 | 4.9
 |  |  |  |  | [NAME]
32 | 2019 | 73 | 5.29
33 | 2019 | 98 | 4.99
34 | 2019 | 112 | 5.14
35 | 2019 | 224 | 4.69
 |  |  |  |  | [NAME]
36 | 2019 | 182 | 4.81
37 | 2019 | 183 | 4.81
38 | 2019 | 142 | 4.87
39 | 2019 | 183 | 5.02
40 | 2019 | 385 | 4.77
 |  |  |  |  | Sep-2019 Average
41 | 2019 | 126 | 5.2
42 | 2019 | 163 | 4.97
43 | 2019 | 217 | 4.95
44 | 2019 | 165 | 4.96
 |  |  |  |  | Oct-2019 Average
45 | 2019 | 207 | 4.37
46 | 2019 | 204 | 4.68
47 | 2019 | 207 | 4.85
48 | 2019 | 267 | 4.86
 |  |  |  |  | [NAME]
49 | 2019 | 160 | 5.21
50 | 2019 | 176 | 4.99
51 | 2019 | 155 | 4.86
52 | 2019 | 43 | 5.56
 |  |  |  |  | [NAME]
1 | 2020 | 64 | 5.9
2 | 2020 | 202 | 5.25
3 | 2020 | 76 | 6.16
4 | 2020 | 279 | 5.25
5 | 2020 | 171 | 5.22
 |  |  |  |  | [NAME]
6 | 2020 | 152 | 5.66
7 | 2020 | 174 | 5.6
8 | 2020 | 240 | 5.79
9 | 2020 | 242 | 5.53
 |  |  |  |  | Feb-2020 Average
10 | 2020 | 236 | 5.59
11 | 2020 | 236 | 5.66
12 | 2020 | 266 | 5.07
13 | 2020 | 186 | 4.51
14 | 2020 | 300 | 4.12
 |  |  |  |  | Mar-2020 Average
15 | 2020 | 101 | 4.13
16 | 2020 | 189 | 4.24
17 | 2020 | 245 | 3.96
18 | 2020 | 199 | 3.97
 |  |  |  |  | Apr-2020 Average
19 | 2020 | 235 | 4.04
20 | 2020 | 262 | 3.97
21 | 2020 | 283 | 4.15
22 | 2020 | 241 | 4.15
23 | 2020 | 327 | 4.36
 |  |  |  |  | May-2020 Average
24 | 2020 | 326 | 4.46
25 | 2020 | 314 | 4.48
26 | 2020 | 427 | 4.24
27 | 2020 | 334 | 4.39
 |  |  |  |  | Jun-2020 Average
28 | 2020 | 393 | 4.23
29 | 2020 | 509 | 3.92
30 | 2020 | 357 | 3.84
 |  |  |  |  | [NAME]
 |  |  |  |  | Grand Average