Spreadsheet: 680423d1591015061-simplest-way-to-filter-dates-2020-06-01-oeldere-complus865-680422d1591013695-simplest-way-to-filter-dates-date-filters
Sheet: Sheet1

Customer ID | Total Invoiced | Date of Purchase DDMMYYYY | month | quartal
71061 | 5248 | 2020-02-01 00:00:00
71183 | 5240 | 2020-02-01 00:00:00
72064 | 5323 | 2020-02-03 00:00:00
71631 | 5263 | 2020-03-02 00:00:00 |  |  |  |  | Quantity
71840 | 5264 | 2020-05-02 00:00:00 |  |  |  | Q1 |  |  | Som van Total Invoiced | Kolomlabels
71842 | 5280 | 2020-05-02 00:00:00 |  |  |  | Q2 |  |  | Rijlabels | 1 | 2 | 3 | 4 | Eindtotaal
71844 | 5287 | 2020-05-02 00:00:00 |  |  |  |  |  |  | 70571 |  |  | 5241 |  | 5241
71356 | 5303 | 2020-06-02 00:00:00 |  |  |  |  |  |  | 70699 | 6749 |  |  |  | 6749
70571 | 5241 | 2020-07-01 00:00:00 |  |  |  |  |  |  | 70700 | 5256 |  |  |  | 5256
70775 | 5219 | 2020-07-01 00:00:00 |  |  |  |  |  |  | 70726 |  |  |  | 5266 | 5266
70726 | 5266 | 2020-10-01 00:00:00 |  |  |  |  |  |  | 70775 |  |  | 5219 |  | 5219
71841 | 5276 | 2020-10-02 00:00:00 |  |  |  |  |  |  | 70776 | 5251 |  |  |  | 5251
71432 | 5284 | 2020-11-02 00:00:00 |  |  |  |  |  |  | 71061 | 5248 |  |  |  | 5248
71737 | 5260 | 2020-11-02 00:00:00 |  |  |  |  |  |  | 71062 | 5259 |  |  |  | 5259
72220 | 5338 | 2020-12-03 00:00:00 |  |  |  |  |  |  | 71063 | 5267 |  |  |  | 5267
71693 | 5270 | 13/02/2020 |  |  |  |  |  |  | 71183 | 5240 |  |  |  | 5240
70699 | 6749 | 14/01/2020 |  |  |  |  |  |  | 71356 |  | 5303 |  |  | 5303
72087 | 5307 | 14/02/2020 |  |  |  |  |  |  | 71432 |  |  |  | 5284 | 5284
71843 | 5282 | 14/02/2020 |  |  |  |  |  |  | 71463 | 5254 |  |  |  | 5254
71606 | 6748 | 15/01/2020 |  |  |  |  |  |  | 71542 | 5261 |  |  |  | 5261
70700 | 5256 | 15/01/2020 |  |  |  |  |  |  | 71606 | 6748 |  |  |  | 6748
71062 | 5259 | 15/01/2020 |  |  |  |  |  |  | 71631 | 5263 |  |  |  | 5263
72685 | 5347 | 15/05/2020 |  |  |  |  |  |  | 71693 | 5270 |  |  |  | 5270
72643 | 5320 | 15/05/2020 |  |  |  |  |  |  | 71737 |  |  |  | 5260 | 5260
72650 | 5321 | 15/05/2020 |  |  |  |  |  |  | 71775 | 5315 |  |  |  | 5315
72632 | 5311 | 15/05/2020 |  |  |  |  |  |  | 71839 | 5216 |  |  |  | 5216
72635 | 5312 | 15/05/2020 |  |  |  |  |  |  | 71840 |  | 5264 |  |  | 5264
71839 | 5216 | 18/02/2020 |  |  |  |  |  |  | 71841 |  |  |  | 5276 | 5276
72255 | 5296 | 18/02/2020 |  |  |  |  |  |  | 71842 |  | 5280 |  |  | 5280
71845 | 5295 | 18/02/2020 |  |  |  |  |  |  | 71843 | 5282 |  |  |  | 5282
72273 | 5359 | 19/03/2020 |  |  |  |  |  |  | 71844 |  | 5287 |  |  | 5287
70776 | 5251 | 20/01/2020 |  |  |  |  |  |  | 71845 | 5295 |  |  |  | 5295
71846 | 5302 | 20/02/2020 |  |  |  |  |  |  | 71846 | 5302 |  |  |  | 5302
72738 | 7610 | 22/05/2020 |  |  |  |  |  |  | 72064 | 5323 |  |  |  | 5323
71463 | 5254 | 23/01/2020 |  |  |  |  |  |  | 72087 | 5307 |  |  |  | 5307
71775 | 5315 | 25/02/2020 |  |  |  |  |  |  | 72220 |  |  |  | 5338 | 5338
72737 | 7611 | 25/05/2020 |  |  |  |  |  |  | 72255 | 5296 |  |  |  | 5296
71063 | 5267 | 29/01/2020 |  |  |  |  |  |  | 72273 | 5359 |  |  |  | 5359
71542 | 5261 | 31/01/2020 |  |  |  |  |  |  | 72632 |  | 5311 |  |  | 5311
 |  |  |  |  |  |  |  |  | 72635 |  | 5312 |  |  | 5312
 |  |  |  |  |  |  |  |  | 72643 |  | 5320 |  |  | 5320
 |  |  |  |  |  |  |  |  | 72650 |  | 5321 |  |  | 5321
 |  |  |  |  |  |  |  |  | 72685 |  | 5347 |  |  | 5347
 |  |  |  |  |  |  |  |  | 72737 |  | 7611 |  |  | 7611
 |  |  |  |  |  |  |  |  | 72738 |  | 7610 |  |  | 7610
 |  |  |  |  |  |  |  |  | Eindtotaal | 113761 | 62966 | 10460 | 26424 | 213611