Spreadsheet: 731394d1620320246-problem-with-averageifs-and-eomonth-test
Sheet: Sheet1

Mon | 2020-03-02 00:00:00 | 49 | 30 | 94.46 | 95
Tue | 2020-03-03 00:00:00 | 32 | 30 | 96.27 | 95
Wed | 2020-03-04 00:00:00 | 21 | 30 | 97.51 | 95 |  |  | Month | Year
Thur | 2020-03-05 00:00:00 | 50 | 30 | 93.68 | 95 | 1 |  | JAN | 2020 | [NAME] | % Calls Answered
Fri | 2020-03-06 00:00:00 | 59 | 30 | 93.24 | 95 |  |  |  | Mon
Sat | 2020-03-07 00:00:00 | 39 | 30 | 94.7 | 95 |  |  |  | Tue
Mon | 2020-03-09 00:00:00 | 29 | 30 | 96.16 | 95 |  |  |  | Wed
Tue | 2020-03-10 00:00:00 | 18 | 30 | 97.31 | 95 |  |  |  | Thur
Wed | 2020-03-11 00:00:00 | 26 | 30 | 96.09 | 95 |  |  |  | Fri
Thur | 2020-03-12 00:00:00 | 28 | 30 | 97.27 | 95 |  |  |  | Sat
Fri | 2020-03-13 00:00:00 | 26 | 30 | 96.41 | 95
Sat | 2020-03-14 00:00:00 | 26 | 30 | 96.06 | 95
Mon | 2020-03-16 00:00:00 | 22 | 30 | 97.89 | 95
Tue | 2020-03-17 00:00:00 | 14 | 30 | 98.26 | 95
Wed | 2020-03-18 00:00:00 | 26 | 30 | 97.86 | 95
Thur | 2020-03-19 00:00:00 | 12 | 30 | 98.62 | 95 |  |  | Jan | 2020
Fri | 2020-03-20 00:00:00 | 24 | 30 | 97.85 | 95 |  |  | Feb | 2021
Sat | 2020-03-21 00:00:00 | 130 | 30 | 86.82 | 95 |  |  | Mar
Mon | 2020-03-23 00:00:00 | 40 | 30 | 96.86 | 95 |  |  | Apr
Tue | 2020-03-24 00:00:00 | 10 | 30 | 98.97 | 95 |  |  | May
Wed | 2020-03-25 00:00:00 | 8 | 30 | 99.26 | 95 |  |  | Jun
Thur | 2020-03-26 00:00:00 | 11 | 30 | 98.44 | 95 |  |  | Jul
Fri | 2020-03-27 00:00:00 | 28 | 30 | 97.24 | 95 |  |  | Aug
Sat | 2020-03-28 00:00:00 | 71 | 30 | 95.83 | 95 |  |  | Sep
Mon | 2020-03-30 00:00:00 | 29 | 30 | 97 | 95 |  |  | Oct
Tue | 2020-03-31 00:00:00 | 20 | 30 | 97.32 | 95 |  |  | Nov
Wed | 2020-04-01 00:00:00 | 17 | 30 | 98.16 | 95 |  |  | Dec
Thur | 2020-04-02 00:00:00 | 12 | 30 | 98.3 | 95
Fri | 2020-04-03 00:00:00 | 16 | 30 | 97.99 | 95
Sat | 2020-04-04 00:00:00 | 23 | 30 | 97.62 | 95
Mon | 2020-04-06 00:00:00 | 16 | 30 | 98.31 | 95
Tue | 2020-04-07 00:00:00 | 12 | 30 | 98.85 | 95
Wed | 2020-04-08 00:00:00 | 12 | 30 | 97.98 | 95
Thur | 2020-04-09 00:00:00 | 20 | 30 | 98.2 | 95
Sat | 2020-04-11 00:00:00 | 168 | 30 | 88.35 | 95
Mon | 2020-04-13 00:00:00 | 90 | 30 | 92.11 | 95
Tue | 2020-04-14 00:00:00 | 19 | 30 | 98.56 | 95
Wed | 2020-04-15 00:00:00 | 18 | 30 | 98.55 | 95
Thur | 2020-04-16 00:00:00 | 31 | 30 | 96.25 | 95
Fri | 2020-04-17 00:00:00 | 23 | 30 | 97.9 | 95
Sat | 2020-04-18 00:00:00 | 20 | 30 | 96.83 | 95
Mon | 2020-04-20 00:00:00 | 14 | 30 | 98.88 | 95
Tue | 2020-04-21 00:00:00 | 8 | 30 | 99.17 | 95
Wed | 2020-04-22 00:00:00 | 13 | 30 | 98.72 | 95
Thur | 2020-04-23 00:00:00 | 10 | 30 | 99.19 | 95
Fri | 2020-04-24 00:00:00 | 22 | 30 | 97.79 | 95
Sat | 2020-04-25 00:00:00 | 75 | 30 | 95.2 | 95
Mon | 2020-04-27 00:00:00 | 24 | 30 | 97.53 | 95
Tue | 2020-04-28 00:00:00 | 17 | 30 | 97.27 | 95
Wed | 2020-04-29 00:00:00 | 10 | 30 | 98.5 | 95
Thur | 2020-04-30 00:00:00 | 30 | 30 | 97.41 | 95
Fri | 2020-05-01 00:00:00 | 46 | 30 | 95.38 | 95
Sat | 2020-05-02 00:00:00 | 12 | 30 | 99.07 | 95
Mon | 2020-05-04 00:00:00 | 24 | 30 | 98.3 | 95
Tue | 2020-05-05 00:00:00 | 15 | 30 | 97.9 | 95
Wed | 2020-05-06 00:00:00 | 61 | 30 | 94.1 | 95
Thur | 2020-05-07 00:00:00 | 50 | 30 | 95.41 | 95
Fri | 2020-05-08 00:00:00 | 17 | 30 | 98.7 | 95
Sat | 2020-05-09 00:00:00 | 13 | 30 | 98.35 | 95
Mon | 2020-05-11 00:00:00 | 80 | 30 | 93.82 | 95
Tue | 2020-05-12 00:00:00 | 51 | 30 | 94.71 | 95
Wed | 2020-05-13 00:00:00 | 43 | 30 | 95.19 | 95
Thur | 2020-05-14 00:00:00 | 35 | 30 | 95.41 | 95
Fri | 2020-05-15 00:00:00 | 44 | 30 | 94.59 | 95
Sat | 2020-05-16 00:00:00 | 28 | 30 | 96.91 | 95
Mon | 2020-05-18 00:00:00 | 37 | 30 | 97.14 | 95
Tue | 2020-05-19 00:00:00 | 35 | 30 | 96.67 | 95
wed | 2020-05-20 00:00:00 | 29 | 30 | 97.43 | 95
Thur | 2020-05-21 00:00:00 | 25 | 30 | 98.31 | 95
fri | 2020-05-22 00:00:00 | 56 | 30 | 94.89 | 95
sat | 2020-05-23 00:00:00 | 45 | 30 | 98.26 | 95
Mon | 2020-05-25 00:00:00 | 25 | 30 | 95.54 | 95
Tue | 2020-05-26 00:00:00 | 49 | 30 | 95.07 | 95
wed | 2020-05-27 00:00:00 | 81 | 30 | 92.6 | 95
Thur | 2020-05-28 00:00:00 | 37 | 30 | 96.37 | 95
fri | 2020-05-29 00:00:00 | 51 | 30 | 95.32 | 95
sat | 2020-05-30 00:00:00 | 58 | 30 | 96.61 | 95
Mon | 2020-06-01 00:00:00 | 61 | 30 | 94.74 | 95
Tue | 2020-06-02 00:00:00 | 41 | 30 | 96 | 95
Wed | 2020-06-03 00:00:00 | 40 | 30 | 96.28 | 95
Thur | 2020-06-04 00:00:00 | 40 | 30 | 90.15 | 95
Fri | 2020-06-05 00:00:00 | 84 | 30 | 92.68 | 95
Sat | 2020-06-06 00:00:00 | 39 | 30 | 95.5 | 95
Mon | 2020-06-08 00:00:00 | 92 | 30 | 90.73 | 95
Tue | 2020-06-09 00:00:00 | 39 | 30 | 96.65 | 95
Wed | 2020-06-10 00:00:00 | 56 | 30 | 94.33 | 95
Thur | 2020-06-11 00:00:00 | 62 | 30 | 94.03 | 95
Fri | 2020-06-12 00:00:00 | 70 | 30 | 93.38 | 95
Sat | 2020-06-13 00:00:00 | 63 | 30 | 93.69 | 95
Mon | 2020-06-15 00:00:00 | 55 | 30 | 93.56 | 95
Tue | 2020-06-16 00:00:00 | 84 | 30 | 91.53 | 95
Wed | 2020-06-17 00:00:00 | 60 | 30 | 95.39 | 95
Thur | 2020-06-18 00:00:00 | 58 | 30 | 95.98 | 95
Fri | 2020-06-19 00:00:00 | 44 | 30 | 96.86 | 95
Sat | 2020-06-20 00:00:00 | 41 | 30 | 98 | 95
Mon | 2020-06-22 00:00:00 | 103 | 30 | 91.08 | 95
Tue | 2020-06-23 00:00:00 | 146 | 30 | 85.58 | 95
Wed | 2020-06-24 00:00:00 | 221 | 30 | 81.72 | 95
Thur | 2020-06-25 00:00:00 | 225 | 30 | 83.58 | 95
Fri | 2020-06-26 00:00:00 | 185 | 30 | 83.29 | 95
Sat | 2020-06-27 00:00:00 | 99 | 30 | 94.53 | 95
Mon | 2020-06-29 00:00:00 | 216 | 30 | 83.39 | 95
Tue | 2020-06-30 00:00:00 | 233 | 30 | 81.31 | 95
Wed | 2020-07-01 00:00:00 | 267 | 30 | 76.83 | 95
Thur | 2020-07-02 00:00:00 | 236 | 30 | 81.11 | 95
Fri | 2020-07-03 00:00:00 | 503 | 30 | 62.51 | 95
Sat | 2020-07-04 00:00:00 | 94 | 30 | 92.37 | 95
Mon | 2020-07-06 00:00:00 | 243 | 30 | 81.86 | 95
Tue | 2020-07-07 00:00:00 | 268 | 30 | 77.86 | 95
Wed | 2020-07-08 00:00:00 | 382 | 30 | 69.07 | 95
Thur | 2020-07-09 00:00:00 | 164 | 30 | 83.45 | 95
Fri | 2020-07-10 00:00:00 | 219 | 30 | 80.79 | 95
Sat | 2020-07-11 00:00:00 | 229 | 30 | 80.3 | 95
Mon | 2020-07-13 00:00:00 | 314 | 30 | 73.66 | 95
Tue | 2020-07-14 00:00:00 | 108 | 30 | 90.51 | 95
Wed | 2020-07-15 00:00:00 | 65 | 30 | 94.5 | 95
Thur | 2020-07-16 00:00:00 | 157 | 30 | 84.2 | 95
Fri | 2020-07-17 00:00:00 | 221 | 30 | 81.1 | 95
Sat | 2020-07-18 00:00:00 | 24 | 30 | 97.09 | 95
Mon | 2020-07-20 00:00:00 | 185 | 30 | 85.24 | 95
Tue | 2020-07-21 00:00:00 | 122 | 30 | 89.58 | 95
Wed | 2020-07-22 00:00:00 | 202 | 30 | 78.99 | 95
Thur | 2020-07-23 00:00:00 | 167 | 30 | 84.51 | 95
Fri | 2020-07-24 00:00:00 | 207 | 30 | 81.98 | 95
Sat | 2020-07-25 00:00:00 | 183 | 30 | 86.81 | 95
Mon | 2020-07-27 00:00:00 | 343 | 30 | 74.47 | 95
Tue | 2020-07-28 00:00:00 | 70 | 30 | 93.67 | 95
Wed | 2020-07-29 00:00:00 | 246 | 30 | 78.55 | 95
Thur | 2020-07-30 00:00:00 | 70 | 30 | 92.73 | 95
Fri | 2020-07-31 00:00:00 | 138 | 30 | 89.44 | 95
Fri | 2020-08-07 00:00:00 | 210 | 30 | 84.5 | 95
fri | 2020-08-14 00:00:00 | 353 | 30 | 72.58 | 95
Fri | 2020-08-21 00:00:00 | 261 | 30 | 78.59 | 95
Fri | 2020-08-28 00:00:00 | 343 | 30 | 74.8 | 95
Mon | 2020-08-03 00:00:00 | 206 | 30 | 82.61 | 95
Mon | 2020-08-10 00:00:00 | 220 | 30 | 83.03 | 95
Mon | 2020-08-17 00:00:00 | 264 | 30 | 81.62 | 95
Mon | 2020-08-24 00:00:00 | 372 | 30 | 76.01 | 95
Mon | 2020-08-31 00:00:00 | 128 | 30 | 91.48 | 95
Sat | 2020-08-01 00:00:00 | 174 | 30 | 86.03 | 95
Sat | 2020-08-08 00:00:00 | 68 | 30 | 94.7 | 95
Sat | 2020-08-15 00:00:00 | 177 | 30 | 87.82 | 95
Sat | 2020-08-22 00:00:00 | 65 | 30 | 95 | 95
Sat | 2020-08-29 00:00:00 | 79 | 30 | 97.6 | 95
Thur | 2020-08-06 00:00:00 | 225 | 30 | 81.72 | 95
Thur | 2020-08-13 00:00:00 | 328 | 30 | 74.83 | 95
Thur | 2020-08-20 00:00:00 | 277 | 30 | 80.13 | 95
Thur | 2020-08-27 00:00:00 | 342 | 30 | 74.32 | 95
Tue | 2020-08-04 00:00:00 | 92 | 30 | 90.45 | 95
Tue | 2020-08-11 00:00:00 | 100 | 30 | 92.24 | 95
Tue | 2020-08-18 00:00:00 | 234 | 30 | 82.25 | 95
Tue | 2020-08-25 00:00:00 | 416 | 30 | 71.15 | 95
Wed | 2020-08-05 00:00:00 | 261 | 30 | 78.7 | 95
Wed | 2020-08-19 00:00:00 | 267 | 30 | 79.31 | 95
Wed | 2020-08-26 00:00:00 | 705 | 30 | 56.31 | 95
wed | 2020-08-12 00:00:00 | 374 | 30 | 74.29 | 95
Tue | 2020-09-01 00:00:00 | 552 | 30 | 60.22 | 95
wed | 2020-09-02 00:00:00 | 619 | 30 | 56.25 | 95
Thur | 2020-09-03 00:00:00 | 599 | 30 | 61 | 95
Fri | 2020-09-04 00:00:00 | 455 | 30 | 71.79 | 95
Sat | 2020-09-05 00:00:00 | 173 | 30 | 88.81 | 95
Mon | 2020-09-07 00:00:00 | 240 | 30 | 80.45 | 95
Tue | 2020-09-08 00:00:00 | 233 | 30 | 81.52 | 95
Wed | 2020-09-09 00:00:00 | 233 | 30 | 81..84 | 95
Thur | 2020-09-10 00:00:00 | 73 | 30 | 91.2 | 95
Fri | 2020-09-11 00:00:00 | 173 | 30 | 87.44 | 95
Sat | 2020-09-12 00:00:00 | 140 | 30 | 88.57 | 95
Mon | 2020-09-14 00:00:00 | 212 | 30 | 86.76 | 95
Tue | 2020-09-15 00:00:00 | 126 | 30 | 90.11 | 95
Wed | 2020-09-16 00:00:00 | 153 | 30 | 89.04 | 95
Thur | 2020-09-17 00:00:00 | 101 | 30 | 91.42 | 95
Fri | 2020-09-18 00:00:00 | 127 | 30 | 92.1 | 95
Sat | 2020-09-19 00:00:00 | 44 | 30 | 94.9 | 95
Mon | 2020-09-21 00:00:00 | 243 | 30 | 83.5 | 95
Tue | 2020-09-22 00:00:00 | 210 | 30 | 87.24 | 95
Wed | 2020-09-23 00:00:00 | 298 | 30 | 80.1 | 95
Thur | 2020-09-24 00:00:00 | 261 | 30 | 85.45 | 95
Fri | 2020-09-25 00:00:00 | 257 | 30 | 85.37 | 95
Sat | 2020-09-26 00:00:00 | 94 | 30 | 95.54 | 95
Mon | 2020-09-28 00:00:00 | 357 | 30 | 77.33 | 95
Tue | 2020-09-29 00:00:00 | 131 | 30 | 91.14 | 95
Wed | 2020-09-30 00:00:00 | 249 | 30 | 85.38 | 95
Thur | 2020-10-01 00:00:00 | 216 | 30 | 85.81 | 95
Fri | 2020-10-02 00:00:00 | 312 | 30 | 82.09 | 95
Sat | 2020-10-03 00:00:00 | 547 | 30 | 73.55 | 95
Mon | 2020-10-05 00:00:00 | 294 | 30 | 78.78 | 95
Tue | 2020-10-06 00:00:00 | 273 | 30 | 83.25 | 95
Wed | 2020-10-07 00:00:00 | 244 | 30 | 85.98 | 95
Thur | 2020-10-08 00:00:00 | 455 | 30 | 75.71 | 95
Fri | 2020-10-09 00:00:00 | 196 | 30 | 85.57 | 95
Sat | 2020-10-10 00:00:00 | 153 | 30 | 97.94 | 95
Mon | 2020-10-12 00:00:00 | 145 | 30 | 90.91 | 95
Tue | 2020-10-13 00:00:00 | 174 | 30 | 88.13 | 95
Wed | 2020-10-14 00:00:00 | 134 | 30 | 90.83 | 95
Thur | 2020-10-15 00:00:00 | 216 | 30 | 86.9 | 95
Fri | 2020-10-16 00:00:00 | 121 | 30 | 92.39 | 95
Sat | 2020-10-17 00:00:00 | 207 | 30 | 88.98 | 95
Mon | 2020-10-19 00:00:00 | 92 | 30 | 93.24 | 95
Tue | 2020-10-20 00:00:00 | 176 | 30 | 85.33 | 95
Wed | 2020-10-21 00:00:00 | 142 | 30 | 90.75 | 95
Thur | 2020-10-22 00:00:00 | 260 | 30 | 82.23 | 95
Fri | 2020-10-23 00:00:00 | 269 | 30 | 83.88 | 95
Sat | 2020-10-24 00:00:00 | 51 | 30 | 97.98 | 95
Mon | 2020-10-26 00:00:00 | 328 | 30 | 81.5 | 95
Tue | 2020-10-27 00:00:00 | 375 | 30 | 77.22 | 95
Wed | 2020-10-28 00:00:00 | 456 | 30 | 77.24 | 95
Thur | 2020-10-29 00:00:00 | 261 | 30 | 83.33 | 95
Fri | 2020-10-30 00:00:00 | 105 | 30 | 92.97 | 95
Sat | 2020-10-31 00:00:00 | 45 | 30 | 95.61 | 95
Mon | 2020-11-02 00:00:00 | 99 | 30 | 93.03 | 95
Tue | 2020-11-03 00:00:00 | 90 | 30 | 93.2 | 95
Wed | 2020-11-04 00:00:00 | 276 | 30 | 83.32 | 95
Thur | 2020-11-05 00:00:00 | 211 | 30 | 86.63 | 95
Fri | 2020-11-06 00:00:00 | 273 | 30 | 83.6 | 95
Sat | 2020-11-07 00:00:00 | 582 | 30 | 63.33 | 95
Mon | 2020-11-09 00:00:00 | 212 | 30 | 85.17 | 95
Tue | 2020-11-10 00:00:00 | 204 | 30 | 84.75 | 95
Wed | 2020-11-11 00:00:00 | 238 | 30 | 81.66 | 95
Thur | 2020-11-12 00:00:00 | 0 | 30 | 0 | 95
Fri | 2020-11-13 00:00:00 | 306 | 30 | 82.13 | 95
Sat | 2020-11-14 00:00:00 | 140 | 30 | 94.62 | 95
Mon | 2020-11-16 00:00:00 | 399 | 30 | 71.29 | 95
Tue | 2020-11-17 00:00:00 | 279 | 30 | 80.18 | 95
Wed | 2020-11-18 00:00:00 | 396 | 30 | 73.38 | 95
Thur | 2020-11-19 00:00:00 | 196 | 30 | 84.29 | 95
Fri | 2020-11-20 00:00:00 | 235 | 30 | 83.01 | 95
Sat | 2020-11-21 00:00:00 | 162 | 30 | 90.76 | 95
Mon | 2020-11-23 00:00:00 | 302 | 30 | 80.48 | 95
Tue | 2020-11-24 00:00:00 | 203 | 30 | 85.77 | 95
Wed | 2020-11-25 00:00:00 | 408 | 30 | 72.79 | 95
Thur | 2020-11-26 00:00:00 | 323 | 30 | 78.33 | 95
Fri | 2020-11-27 00:00:00 | 383 | 30 | 74.2 | 95
Sat | 2020-11-28 00:00:00 | 272 | 30 | 82.27 | 95
Mon | 2020-11-30 00:00:00 | 395 | 30 | 72.1 | 95
Tue | 2020-12-01 00:00:00 | 271 | 30 | 80.28 | 95
Wed | 2020-12-02 00:00:00 | 389 | 30 | 75.14 | 95
Thur | 2020-12-03 00:00:00 | 355 | 30 | 76.94 | 95
Fri | 2020-12-04 00:00:00 | 459 | 30 | 74.27 | 95
Sat | 2020-12-05 00:00:00 | 347 | 30 | 79.47 | 95
Mon | 2020-12-07 00:00:00 | 406 | 30 | 71.83 | 95
Tue | 2020-12-08 00:00:00 | 502 | 30 | 67.7 | 95
Wed | 2020-12-09 00:00:00 | 572 | 30 | 63.58 | 95
Thur | 2020-12-10 00:00:00 | 136 | 30 | 89.81 | 95
Fri | 2020-12-11 00:00:00 | 371 | 30 | 73.1 | 95
Sat | 2020-12-12 00:00:00 | 102 | 30 | 91.23 | 95
Mon | 2020-12-14 00:00:00 | 328 | 30 | 80.63 | 95
Tue | 2020-12-15 00:00:00 | 251 | 30 | 81.4 | 95
Wed | 2020-12-16 00:00:00 | 417 | 30 | 75.09 | 95
Thur | 2020-12-17 00:00:00 | 230 | 30 | 83.48 | 95
Fri | 2020-12-18 00:00:00 | 164 | 30 | 88.17 | 95
Sat | 2020-12-19 00:00:00 | 407 | 30 | 79.91 | 95
Mon | 2020-12-21 00:00:00 | 307 | 30 | 88.01 | 95
Tue | 2020-12-22 00:00:00 | 384 | 30 | 80.1 | 95
Wed | 2020-12-23 00:00:00 | 432 | 30 | 74.38 | 95
Thur | 2020-12-24 00:00:00 | 78 | 30 | 92 | 95
Mon | 2020-12-28 00:00:00 | 116 | 30 | 94.95 | 95
Tue | 2020-12-29 00:00:00 | 409 | 30 | 78.95 | 95
Wed | 2020-12-30 00:00:00 | 191 | 30 | 90.96 | 95
Thur | 2020-12-31 00:00:00 | 125 | 30 | 89.53 | 95