Spreadsheet: 839472d1692014147-how-to-create-a-dynamic-date-dynamic-data-1
Sheet: SM_REPORT

 |  |  |  | Table A
 |  |  |  | Date | Total Sales | Total Receipts | Total Units
 |  |  |  | 2023-01-01 00:00:00 | 12275 | 13 | 20
 |  |  |  | 2023-01-02 00:00:00 | 8735 | 6 | 12
 |  |  |  | 2023-01-04 00:00:00 | 6090 | 5 | 8
 |  |  |  | 2023-01-05 00:00:00 | 19880 | 20 | 26
 |  |  |  | 2023-01-06 00:00:00 | 33920 | 27 | 45
 |  |  |  | 2023-01-07 00:00:00 | 26755 | 27 | 35
 |  |  |  | 2023-01-08 00:00:00 | 32090 | 24 | 43
 |  |  |  | 2023-01-09 00:00:00 | 38195 | 34 | 50
 |  |  |  | 2023-01-10 00:00:00 | 54870 | 46 | 73
 |  |  |  | 2023-01-11 00:00:00 | 41610 | 35 | 55
 |  |  |  | 2023-01-12 00:00:00 | 39460 | 32 | 52
 |  |  |  | 2023-01-13 00:00:00 | 46955 | 36 | 62
 |  |  |  | 2023-01-14 00:00:00 | 46205 | 39 | 61
 |  |  |  | 2023-01-15 00:00:00 | 44510 | 37 | 59
 |  |  |  | 2023-01-16 00:00:00 | 49105 | 43 | 65
 |  |  |  | 2023-01-17 00:00:00 | 46955 | 43 | 62
 |  |  |  | 2023-01-18 00:00:00 | 43660 | 34 | 58
 |  |  |  | 2023-01-19 00:00:00 | 52950 | 44 | 70
 |  |  |  | 2023-01-20 00:00:00 | 39140 | 33 | 51
 |  |  |  | 2023-01-21 00:00:00 | 44280 | 34 | 59
 |  |  |  | 2023-01-22 00:00:00 | 35615 | 32 | 47
 |  |  |  | 2023-01-23 00:00:00 | 46205 | 34 | 61
 |  |  |  | 2023-01-24 00:00:00 | 36820 | 34 | 49
 |  |  |  | 2023-01-25 00:00:00 | 31770 | 31 | 42
 |  |  |  | 2023-01-26 00:00:00 | 33465 | 26 | 44
 |  |  |  | 2023-01-27 00:00:00 | 31770 | 30 | 42
 |  |  |  | 2023-01-28 00:00:00 | 29225 | 21 | 39
 |  |  |  | 2023-01-29 00:00:00 | 34315 | 32 | 45
 |  |  |  | 2023-01-30 00:00:00 | 47185 | 41 | 62
 |  |  |  | 2023-01-31 00:00:00 | 47180 | 42 | 63
 |  |  |  | 2023-02-01 00:00:00 | 37540 | 34 | 49
 |  |  |  | 2023-02-02 00:00:00 | 52950 | 42 | 70
 |  |  |  | 2023-02-03 00:00:00 | 34990 | 37 | 47
 |  |  |  | 2023-02-04 00:00:00 | 56795 | 42 | 75
 |  |  |  | 2023-02-05 00:00:00 | 38515 | 39 | 51
 |  |  |  | 2023-02-06 00:00:00 | 81820 | 62 | 108
 |  |  |  | 2023-02-07 00:00:00 | 102055 | 64 | 135
 |  |  |  | 2023-02-08 00:00:00 | 34315 | 30 | 45
 |  |  |  | 2023-02-09 00:00:00 | 43660 | 38 | 58
 |  |  |  | 2023-02-10 00:00:00 | 77880 | 72 | 103
 |  |  |  | 2023-02-11 00:00:00 | 71230 | 60 | 94
 |  |  |  | 2023-02-12 00:00:00 | 57545 | 56 | 76
 |  |  |  | 2023-02-13 00:00:00 | 71265 | 71 | 94
 |  |  |  | 2023-02-14 00:00:00 | 142685 | 123 | 189
 |  |  |  | 2023-02-15 00:00:00 | 52645 | 46 | 67
 |  |  |  | 2023-02-16 00:00:00 | 53725 | 48 | 72
 |  |  |  | 2023-02-17 00:00:00 | 52100 | 51 | 69
 |  |  |  | 2023-02-18 00:00:00 | 42040 | 43 | 55
 |  |  |  | 2023-02-19 00:00:00 | 58715 | 50 | 78
 |  |  |  | 2023-02-20 00:00:00 | 42360 | 42 | 56
 |  |  |  | 2023-02-21 00:00:00 | 26325 | 26 | 35
 |  |  |  | 2023-02-22 00:00:00 | 22780 | 26 | 30
 |  |  |  | 2023-02-23 00:00:00 | 23330 | 19 | 31
 |  |  |  | 2023-02-24 00:00:00 | 18280 | 19 | 24
 |  |  |  | 2023-02-25 00:00:00 | 9740 | 11 | 13
 |  |  |  | 2023-02-26 00:00:00 | 30470 | 18 | 40
 |  |  |  | 2023-02-27 00:00:00 | 22160 | 22 | 29
 |  |  |  | 2023-02-28 00:00:00 | 31770 | 28 | 42
 |  |  |  | 2023-03-01 00:00:00 | 26945 | 24 | 36
 |  |  |  | 2023-03-02 00:00:00 | 31770 | 29 | 42
 |  |  |  | 2023-03-03 00:00:00 | 21180 | 22 | 28
 |  |  |  | 2023-03-04 00:00:00 | 29225 | 21 | 39
 |  |  |  | 2023-03-05 00:00:00 | 24705 | 21 | 32
 |  |  |  | 2023-03-06 00:00:00 | 38515 | 31 | 51
 |  |  |  | 2023-03-07 00:00:00 | 27890 | 24 | 37
 |  |  |  | 2023-03-08 00:00:00 | 83025 | 61 | 110
 |  |  |  | 2023-03-09 00:00:00 | 9420 | 9 | 12
 |  |  |  | 2023-03-10 00:00:00 | 14755 | 15 | 20
 |  |  |  | 2023-03-11 00:00:00 | 11440 | 11 | 15
 |  |  |  | 2023-03-12 00:00:00 | 4595 | 6 | 6
 |  |  |  | 2023-03-13 00:00:00 | 11570 | 10 | 15
 |  |  |  | 2023-03-14 00:00:00 | 9610 | 7 | 13
 |  |  |  | 2023-03-15 00:00:00 | 15415 | 13 | 20
 |  |  |  | 2023-03-16 00:00:00 | 9610 | 6 | 13
 |  |  |  | 2023-03-17 00:00:00 | 6745 | 7 | 9
 |  |  |  | 2023-03-18 00:00:00 | 6745 | 4 | 9
 |  |  |  | 2023-03-19 00:00:00 | 12740 | 10 | 17
 |  |  |  | 2023-03-20 00:00:00 | 15185 | 13 | 20
 |  |  |  | 2023-03-21 00:00:00 | 6745 | 5 | 9
 |  |  |  | 2023-03-22 00:00:00 | 7690 | 8 | 10
 |  |  |  | 2023-03-23 00:00:00 | 6745 | 7 | 9
 |  |  |  | 2023-03-24 00:00:00 | 10590 | 8 | 14
 |  |  |  | 2023-03-25 00:00:00 | 5995 | 5 | 8
 |  |  |  | 2023-03-26 00:00:00 | 8440 | 6 | 11
 |  |  |  | 2023-03-27 00:00:00 | 19580 | 13 | 26
 |  |  |  | 2023-03-28 00:00:00 | 10590 | 9 | 14
 |  |  |  | 2023-03-29 00:00:00 | 9290 | 9 | 12
 |  |  |  | 2023-03-30 00:00:00 | 2150 | 2 | 3
 |  |  |  | 2023-03-31 00:00:00 | 9420 | 6 | 12
 |  |  |  | 2023-04-01 00:00:00 | 12510 | 10 | 17
 |  |  |  | 2023-04-02 00:00:00 | 5145 | 6 | 7
 |  |  |  | 2023-04-03 00:00:00 | 12190 | 9 | 16
 |  |  |  | 2023-04-04 00:00:00 | 3095 | 4 | 4
 |  |  |  | 2023-04-05 00:00:00 | 15185 | 13 | 20
 |  |  |  | 2023-04-06 00:00:00 | 7725 | 8 | 10
 |  |  |  | 2023-04-07 00:00:00 | 8860 | 7 | 12
 |  |  |  | 2023-04-08 00:00:00 | 10590 | 8 | 14
 |  |  |  | 2023-04-09 00:00:00 | 8440 | 9 | 11
 |  |  |  | 2023-04-10 00:00:00 | 10590 | 8 | 14
 |  |  |  | 2023-04-11 00:00:00 | 7725 | 6 | 10
 |  |  |  | 2023-04-12 00:00:00 | 9610 | 10 | 13
 |  |  |  | 2023-04-13 00:00:00 | 11890 | 14 | 16
 |  |  |  | 2023-04-14 00:00:00 | 4695 | 6 | 6
 |  |  |  | 2023-04-15 00:00:00 | 5895 | 4 | 8
 |  |  |  | 2023-04-16 00:00:00 | 16035 | 12 | 21
 |  |  |  | 2023-04-17 00:00:00 | 11890 | 12 | 16
 |  |  |  | 2023-04-18 00:00:00 | 23725 | 20 | 31
 |  |  |  | 2023-04-19 00:00:00 | 29225 | 18 | 39
 |  |  |  | 2023-04-20 00:00:00 | 17960 | 9 | 23
 |  |  |  | 2023-04-21 00:00:00 | 17335 | 12 | 23
 |  |  |  | 2023-04-22 00:00:00 | 25025 | 15 | 33
 |  |  |  | 2023-04-23 00:00:00 | 13810 | 10 | 19
 |  |  |  | 2023-04-24 00:00:00 | 14115 | 9 | 18
 |  |  |  | 2023-04-25 00:00:00 | 16355 | 13 | 22
 |  |  |  | 2023-04-26 00:00:00 | 14435 | 11 | 19
 |  |  |  | 2023-04-27 00:00:00 | 26325 | 18 | 35
 |  |  |  | 2023-04-28 00:00:00 | 13170 | 9 | 17
 |  |  |  | 2023-04-29 00:00:00 | 20200 | 15 | 27
 |  |  |  | 2023-04-30 00:00:00 | 25025 | 16 | 33
 |  |  |  | 2023-05-01 00:00:00 | 15415 | 14 | 20
 |  |  |  | 2023-05-02 00:00:00 | 10590 | 8 | 14
 |  |  |  | 2023-05-03 00:00:00 | 9610 | 7 | 13
 |  |  |  | 2023-05-04 00:00:00 | 18635 | 15 | 25
 |  |  |  | 2023-05-05 00:00:00 | 21180 | 15 | 28
 |  |  |  | 2023-05-06 00:00:00 | 14435 | 12 | 19
 |  |  |  | 2023-05-07 00:00:00 | 22030 | 19 | 29
 |  |  |  | 2023-05-08 00:00:00 | 20010 | 17 | 26
 |  |  |  | 2023-05-09 00:00:00 | 13490 | 12 | 18
 |  |  |  | 2023-05-10 00:00:00 | 12510 | 15 | 17
 |  |  |  | 2023-05-11 00:00:00 | 16360 | 14 | 21
 |  |  |  | 2023-05-12 00:00:00 | 21500 | 21 | 29
 |  |  |  | 2023-05-13 00:00:00 | 24930 | 21 | 33
 |  |  |  | 2023-05-14 00:00:00 | 27700 | 22 | 36
 |  |  |  | 2023-05-15 00:00:00 | 35840 | 35 | 48
 |  |  |  | 2023-05-16 00:00:00 | 24175 | 25 | 32
 |  |  |  | 2023-05-17 00:00:00 | 22780 | 19 | 30
 |  |  |  | 2023-05-18 00:00:00 | 12515 | 9 | 16
 |  |  |  | 2023-05-19 00:00:00 | 38835 | 28 | 52
 |  |  |  | 2023-05-20 00:00:00 | 46205 | 35 | 61
 |  |  |  | 2023-05-21 00:00:00 | 18935 | 18 | 25
 |  |  |  | 2023-05-22 00:00:00 | 31770 | 27 | 42
 |  |  |  | 2023-05-23 00:00:00 | 40440 | 37 | 53
 |  |  |  | 2023-05-24 00:00:00 | 24045 | 21 | 32
 |  |  |  | 2023-05-25 00:00:00 | 30075 | 24 | 40
 |  |  |  | 2023-05-26 00:00:00 | 28675 | 30 | 38
 |  |  |  | 2023-05-27 00:00:00 | 30170 | 26 | 40
 |  |  |  | 2023-05-28 00:00:00 | 28870 | 23 | 38
 |  |  |  | 2023-05-29 00:00:00 | 22780 | 19 | 30
 |  |  |  | 2023-05-30 00:00:00 | 19575 | 15 | 23
 |  |  |  | 2023-05-31 00:00:00 | 26155 | 25 | 36
 |  |  |  | 2023-06-01 00:00:00 | 18280 | 15 | 24
 |  |  |  | 2023-06-02 00:00:00 | 22160 | 24 | 29
 |  |  |  | 2023-06-03 00:00:00 | 21500 | 21 | 29
 |  |  |  | 2023-06-04 00:00:00 | 27925 | 23 | 37
 |  |  |  | 2023-06-05 00:00:00 | 49730 | 26 | 65
 |  |  |  | 2023-06-06 00:00:00 | 43530 | 36 | 58
 |  |  |  | 2023-06-07 00:00:00 | 30600 | 23 | 40
 |  |  |  | 2023-06-08 00:00:00 | 34670 | 26 | 46
 |  |  |  | 2023-06-09 00:00:00 | 16355 | 14 | 22
 |  |  |  | 2023-06-10 00:00:00 | 31770 | 21 | 42
 |  |  |  | 2023-06-11 00:00:00 | 56045 | 42 | 74
 |  |  |  | 2023-06-12 00:00:00 | 28675 | 25 | 38
 |  |  |  | 2023-06-13 00:00:00 | 26325 | 21 | 35
 |  |  |  | 2023-06-14 00:00:00 | 19880 | 22 | 26
 |  |  |  | 2023-06-15 00:00:00 | 27925 | 21 | 37
 |  |  |  | 2023-06-16 00:00:00 | 19260 | 16 | 25
 |  |  |  | 2023-06-17 00:00:00 | 36785 | 23 | 49
 |  |  |  | 2023-06-18 00:00:00 | 20330 | 18 | 27
 |  |  |  | 2023-06-19 00:00:00 | 22030 | 17 | 29
 |  |  |  | 2023-06-20 00:00:00 | 32520 | 25 | 43
 |  |  |  | 2023-06-21 00:00:00 | 17335 | 17 | 23
 |  |  |  | 2023-06-22 00:00:00 | 13685 | 13 | 18
 |  |  |  | 2023-06-23 00:00:00 | 24830 | 21 | 33
 |  |  |  | 2023-06-24 00:00:00 | 15380 | 18 | 20
 |  |  |  | 2023-06-25 00:00:00 | 29225 | 17 | 39
 |  |  |  | 2023-06-26 00:00:00 | 32620 | 23 | 43
 |  |  |  | 2023-06-27 00:00:00 | 27925 | 15 | 37
 |  |  |  | 2023-06-28 00:00:00 | 41190 | 25 | 54
 |  |  |  | 2023-06-29 00:00:00 | 19450 | 18 | 26
 |  |  |  | 2023-06-30 00:00:00 | 25775 | 19 | 34
 |  |  |  | 2023-07-01 00:00:00 | 18315 | 15 | 24
 |  |  |  | 2023-07-02 00:00:00 | 22350 | 20 | 30
 |  |  |  | 2023-07-03 00:00:00 | 14435 | 12 | 19
 |  |  |  | 2023-07-04 00:00:00 | 11340 | 10 | 15
 |  |  |  | 2023-07-05 00:00:00 | 8990 | 8 | 12
 |  |  |  | 2023-07-06 00:00:00 | 22030 | 17 | 29
 |  |  |  | 2023-07-07 00:00:00 | 20330 | 19 | 27
 |  |  |  | 2023-07-08 00:00:00 | 14115 | 12 | 18
 |  |  |  | 2023-07-09 00:00:00 | 17655 | 15 | 24
 |  |  |  | 2023-07-10 00:00:00 | 17335 | 12 | 23
 |  |  |  | 2023-07-11 00:00:00 | 18280 | 19 | 24
 |  |  |  | 2023-07-12 00:00:00 | 7595 | 9 | 10
 |  |  |  | 2023-07-13 00:00:00 | 15185 | 11 | 20
 |  |  |  | 2023-07-14 00:00:00 | 11570 | 10 | 15
 |  |  |  | 2023-07-15 00:00:00 | 18600 | 12 | 25
 |  |  |  | 2023-07-16 00:00:00 | 17335 | 15 | 23
 |  |  |  | 2023-07-17 00:00:00 | 21180 | 19 | 28
 |  |  |  | 2023-07-18 00:00:00 | 14435 | 17 | 19
 |  |  |  | 2023-07-19 00:00:00 | 9290 | 9 | 12
 |  |  |  | 2023-07-20 00:00:00 | 11570 | 14 | 15
 |  |  |  | 2023-07-21 00:00:00 | 12510 | 10 | 17
 |  |  |  | 2023-07-22 00:00:00 | 31770 | 25 | 42
 |  |  |  | 2023-07-23 00:00:00 | 9840 | 11 | 13
 |  |  |  | 2023-07-24 00:00:00 | 22910 | 16 | 30
 |  |  |  | 2023-07-25 00:00:00 | 25025 | 25 | 33
 |  |  |  | 2023-07-26 00:00:00 | 17335 | 17 | 23
 |  |  |  | 2023-07-27 00:00:00 | 33690 | 27 | 45
 |  |  |  | 2023-07-28 00:00:00 | 13685 | 13 | 18
 |  |  |  | 2023-07-29 00:00:00 | 13265 | 11 | 17
 |  |  |  | 2023-07-30 00:00:00 | 21500 | 19 | 29
 |  |  |  | 2023-07-31 00:00:00 | 20860 | 18 | 27
 |  |  |  | 2023-08-01 00:00:00 | 13490 | 15 | 18
 |  |  |  | 2023-08-02 00:00:00 | 18280 | 19 | 24
 |  |  |  | 2023-08-03 00:00:00 | 14660 | 18 | 20
 |  |  |  | 2023-08-04 00:00:00 | 27700 | 20 | 36
 |  |  |  | 2023-08-05 00:00:00 | 15410 | 11 | 21
 |  |  |  | 2023-08-06 00:00:00 | 19260 | 16 | 25
 |  |  |  | 2023-08-07 00:00:00 | 32940 | 30 | 44
 |  |  |  | 2023-08-08 00:00:00 | 31770 | 23 | 42
 |  |  |  | 2023-08-09 00:00:00 | 23855 | 21 | 31
 |  |  |  | 2023-08-10 00:00:00 | 24045 | 28 | 32
 |  |  |  | 2023-08-11 00:00:00 | 15640 | 20 | 21
 |  |  |  | 2023-08-12 00:00:00 | 23855 | 23 | 31
 |  |  |  | 2023-08-13 00:00:00 | 35935 | 31 | 48
 |  |  |  | 2023-08-14 00:00:00 | 40115 | 34 | 53
 |  |  |  | 2023-08-15 00:00:00 | 18280 | 19 | 24
 |  |  |  | 2023-08-16 00:00:00 | 30075 | 22 | 40
 |  |  |  | 2023-08-17 00:00:00 | 20010 | 16 | 26
 |  |  |  | 2023-08-18 00:00:00 | 39460 | 29 | 52
 |  |  |  | 2023-08-19 00:00:00 | 43530 | 34 | 58
 |  |  |  | 2023-08-20 00:00:00 | 41510 | 35 | 55
 |  |  |  | 2023-08-21 00:00:00 | 21180 | 19 | 28
 |  |  |  | 2023-08-22 00:00:00 | 43210 | 30 | 57
 |  |  |  | 2023-08-23 00:00:00 | 34670 | 24 | 46
 |  |  |  | 2023-08-24 00:00:00 | 36910 | 26 | 46
 |  |  |  | 2023-08-25 00:00:00 | 40365 | 32 | 54
 |  |  |  | 2023-08-26 00:00:00 | 23100 | 21 | 31
 |  |  |  | 2023-08-27 00:00:00 | 17335 | 16 | 23
 |  |  |  | 2023-08-28 00:00:00 | 24275 | 23 | 32
 |  |  |  | 2023-08-29 00:00:00 | 26755 | 21 | 35
 |  |  |  | 2023-08-30 00:00:00 | 32940 | 20 | 44
 |  |  |  | 2023-08-31 00:00:00 | 11340 | 11 | 15
 |  |  |  | 2023-09-01 00:00:00 | 19260 | 16 | 25
 |  |  |  | 2023-09-02 00:00:00 | 42680 | 36 | 57
 |  |  |  | 2023-09-03 00:00:00 | 33370 | 29 | 44
 |  |  |  | 2023-09-04 00:00:00 | 51350 | 41 | 68
 |  |  |  | 2023-09-05 00:00:00 | 49105 | 29 | 65
 |  |  |  | 2023-09-06 00:00:00 | 25025 | 26 | 33
 |  |  |  | 2023-09-07 00:00:00 | 38515 | 30 | 51
 |  |  |  | 2023-09-08 00:00:00 | 51650 | 45 | 68
 |  |  |  | 2023-09-09 00:00:00 | 31020 | 21 | 41
 |  |  |  | 2023-09-10 00:00:00 | 52100 | 34 | 69
 |  |  |  | 2023-09-11 00:00:00 | 43210 | 37 | 57
 |  |  |  | 2023-09-12 00:00:00 | 86770 | 56 | 115
 |  |  |  | 2023-09-13 00:00:00 | 56475 | 40 | 74
 |  |  |  | 2023-09-14 00:00:00 | 41380 | 23 | 55
 |  |  |  | 2023-09-15 00:00:00 | 24080 | 15 | 32
 |  |  |  | 2023-09-16 00:00:00 | 27925 | 20 | 37
 |  |  |  | 2023-09-17 00:00:00 | 25970 | 25 | 34
 |  |  |  | 2023-09-18 00:00:00 | 54250 | 33 | 72
 |  |  |  | 2023-09-19 00:00:00 | 56700 | 41 | 75
 |  |  |  | 2023-09-20 00:00:00 | 21930 | 19 | 29
 |  |  |  | 2023-09-21 00:00:00 | 26950 | 19 | 35
 |  |  |  | 2023-09-22 00:00:00 | 17655 | 15 | 24
 |  |  |  | 2023-09-23 00:00:00 | 28775 | 23 | 38
 |  |  |  | 2023-09-24 00:00:00 | 43110 | 31 | 57
 |  |  |  | 2023-09-25 00:00:00 | 52200 | 36 | 69
 |  |  |  | 2023-09-26 00:00:00 | 26720 | 20 | 35
 |  |  |  | 2023-09-27 00:00:00 | 27925 | 19 | 37
 |  |  |  | 2023-09-28 00:00:00 | 22480 | 20 | 30
 |  |  |  | 2023-09-29 00:00:00 | 25875 | 25 | 34
 |  |  |  | 2023-09-30 00:00:00 | 21930 | 20 | 29