Spreadsheet: 754148d1635963274-date-range-on-master-sheet-to-populate-month-sheets-following-filter-within-date-range
Sheet: SalesData

Contract Data |  | Start | End
 |  | 2019-04-01 00:00:00 |  |  |  |  |  | =DATE(YEAR(C2),MONTH(C2)+1,DAY(C2)-1)
 |  |  | TOTAL |  |  |  |  | =SUBTOTAL(109,E5:E201)
Open | Close | Customer | Service | Total | Range
2019-01-01 00:00:00 |  | Name 1 | Contract1 | 1
2019-01-02 00:00:00 |  | Name 2 | Contract2 | 1
2019-01-03 00:00:00 |  | Name 3 | Contract3 | 1
2019-01-04 00:00:00 |  | Name 4 | Contract4 | 1
2019-01-05 00:00:00 |  | Name 5 | Contract5 | 1
2019-01-06 00:00:00 |  | Name 6 | Contract6 | 1
2019-01-07 00:00:00 |  | Name 7 | Contract7 | 1
2019-01-08 00:00:00 |  | Name 8 | Contract8 | 1
2019-01-09 00:00:00 |  | Name 9 | Contract9 | 1
2019-01-10 00:00:00 |  | Name 10 | Contract10 | 1
2019-01-11 00:00:00 |  | Name 11 | Contract11 | 1
2019-01-12 00:00:00 |  | Name 12 | Contract12 | 1
2019-01-13 00:00:00 |  | Name 13 | Contract13 | 1
2019-01-14 00:00:00 |  | Name 14 | Contract14 | 1
2019-01-15 00:00:00 |  | Name 15 | Contract15 | 1
2019-01-16 00:00:00 |  | Name 16 | Contract16 | 1
2019-01-17 00:00:00 |  | Name 17 | Contract17 | 1
2019-01-18 00:00:00 |  | Name 18 | Contract18 | 1
2019-01-19 00:00:00 |  | Name 19 | Contract19 | 1
2019-01-20 00:00:00 |  | Name 20 | Contract20 | 1
2019-01-21 00:00:00 |  | Name 21 | Contract21 | 1
2019-01-22 00:00:00 |  | Name 22 | Contract22 | 1
2019-01-23 00:00:00 |  | Name 23 | Contract23 | 1
2019-01-24 00:00:00 |  | Name 24 | Contract24 | 1
2019-01-25 00:00:00 |  | Name 25 | Contract25 | 1
2019-01-26 00:00:00 |  | Name 26 | Contract26 | 1
2019-01-27 00:00:00 |  | Name 27 | Contract27 | 1
2019-01-28 00:00:00 |  | Name 28 | Contract28 | 1
2019-01-29 00:00:00 |  | Name 29 | Contract29 | 1
2019-01-30 00:00:00 |  | Name 30 | Contract30 | 1
2019-01-31 00:00:00 |  | Name 31 | Contract31 | 1 |  |  |  | =AND(A35<=$D$2,B35>=$C$2)
2019-02-01 00:00:00 |  | Name 32 | Contract32 | 1
2019-02-02 00:00:00 |  | Name 33 | Contract33 | 1
2019-02-03 00:00:00 |  | Name 34 | Contract34 | 1
2019-02-04 00:00:00 |  | Name 35 | Contract35 | 1
2019-02-05 00:00:00 |  | Name 36 | Contract36 | 1
2019-02-06 00:00:00 |  | Name 37 | Contract37 | 1
2019-02-07 00:00:00 |  | Name 38 | Contract38 | 1
2019-02-08 00:00:00 |  | Name 39 | Contract39 | 1
2019-02-09 00:00:00 |  | Name 40 | Contract40 | 1
2019-02-10 00:00:00 |  | Name 41 | Contract41 | 1
2019-02-11 00:00:00 |  | Name 42 | Contract42 | 1
2019-02-12 00:00:00 |  | Name 43 | Contract43 | 1
2019-02-13 00:00:00 |  | Name 44 | Contract44 | 1
2019-02-14 00:00:00 |  | Name 45 | Contract45 | 1
2019-02-15 00:00:00 |  | Name 46 | Contract46 | 1
2019-02-16 00:00:00 |  | Name 47 | Contract47 | 1
2019-02-17 00:00:00 |  | Name 48 | Contract48 | 1
2019-02-18 00:00:00 |  | Name 49 | Contract49 | 1
2019-02-19 00:00:00 |  | Name 50 | Contract50 | 1
2019-02-20 00:00:00 |  | Name 51 | Contract51 | 1
2019-02-21 00:00:00 |  | Name 52 | Contract52 | 1
2019-02-22 00:00:00 |  | Name 53 | Contract53 | 1
2019-02-23 00:00:00 |  | Name 54 | Contract54 | 1
2019-02-24 00:00:00 |  | Name 55 | Contract55 | 1
2019-02-25 00:00:00 |  | Name 56 | Contract56 | 1
2019-02-26 00:00:00 |  | Name 57 | Contract57 | 1
2019-02-27 00:00:00 |  | Name 58 | Contract58 | 1
2019-02-28 00:00:00 |  | Name 59 | Contract59 | 1
2019-03-01 00:00:00 |  | Name 60 | Contract60 | 1
2019-03-02 00:00:00 |  | Name 61 | Contract61 | 1
2019-03-03 00:00:00 |  | Name 62 | Contract62 | 1
2019-03-04 00:00:00 |  | Name 63 | Contract63 | 1
2019-03-05 00:00:00 |  | Name 64 | Contract64 | 1
2019-03-06 00:00:00 |  | Name 65 | Contract65 | 1
2019-03-07 00:00:00 |  | Name 66 | Contract66 | 1
2019-03-08 00:00:00 |  | Name 67 | Contract67 | 1
2019-03-09 00:00:00 |  | Name 68 | Contract68 | 1
2019-03-10 00:00:00 |  | Name 69 | Contract69 | 1
2019-03-11 00:00:00 |  | Name 70 | Contract70 | 1
2019-03-12 00:00:00 |  | Name 71 | Contract71 | 1
2019-03-13 00:00:00 |  | Name 72 | Contract72 | 1
2019-03-14 00:00:00 |  | Name 73 | Contract73 | 1
2019-03-15 00:00:00 |  | Name 74 | Contract74 | 1
2019-03-16 00:00:00 |  | Name 75 | Contract75 | 1
2019-03-17 00:00:00 |  | Name 76 | Contract76 | 1
2019-03-18 00:00:00 |  | Name 77 | Contract77 | 1
2019-03-19 00:00:00 |  | Name 78 | Contract78 | 1
2019-03-20 00:00:00 |  | Name 79 | Contract79 | 1
2019-03-21 00:00:00 |  | Name 80 | Contract80 | 1
2019-03-22 00:00:00 |  | Name 81 | Contract81 | 1
2019-03-23 00:00:00 |  | Name 82 | Contract82 | 1
2019-03-24 00:00:00 |  | Name 83 | Contract83 | 1
2019-03-25 00:00:00 |  | Name 84 | Contract84 | 1
2019-03-26 00:00:00 |  | Name 85 | Contract85 | 1
2019-03-27 00:00:00 |  | Name 86 | Contract86 | 1
2019-03-28 00:00:00 |  | Name 87 | Contract87 | 1
2019-03-29 00:00:00 |  | Name 88 | Contract88 | 1
2019-03-30 00:00:00 |  | Name 89 | Contract89 | 1
2019-03-31 00:00:00 |  | Name 90 | Contract90 | 1
2019-04-01 00:00:00 |  | Name 91 | Contract91 | 1
2019-04-02 00:00:00 |  | Name 92 | Contract92 | 1
2019-04-03 00:00:00 |  | Name 93 | Contract93 | 1
2019-04-04 00:00:00 |  | Name 94 | Contract94 | 1
2019-04-05 00:00:00 |  | Name 95 | Contract95 | 1
2019-04-06 00:00:00 |  | Name 96 | Contract96 | 1
2019-04-07 00:00:00 |  | Name 97 | Contract97 | 1
2019-04-08 00:00:00 |  | Name 98 | Contract98 | 1
2019-04-09 00:00:00 |  | Name 99 | Contract99 | 1
2019-04-10 00:00:00 |  | Name 100 | Contract100 | 1
2019-04-11 00:00:00 |  | Name 101 | Contract101 | 1
2019-04-12 00:00:00 |  | Name 102 | Contract102 | 1
2019-04-13 00:00:00 |  | Name 103 | Contract103 | 1
2019-04-14 00:00:00 |  | Name 104 | Contract104 | 1
2019-04-15 00:00:00 |  | Name 105 | Contract105 | 1
2019-04-16 00:00:00 |  | Name 106 | Contract106 | 1
2019-04-17 00:00:00 |  | Name 107 | Contract107 | 1
2019-04-18 00:00:00 |  | Name 108 | Contract108 | 1
2019-04-19 00:00:00 |  | Name 109 | Contract109 | 1
2019-04-20 00:00:00 |  | Name 110 | Contract110 | 1
2019-04-21 00:00:00 |  | Name 111 | Contract111 | 1
2019-04-22 00:00:00 |  | Name 112 | Contract112 | 1
2019-04-23 00:00:00 |  | Name 113 | Contract113 | 1
2019-04-24 00:00:00 |  | Name 114 | Contract114 | 1
2019-04-25 00:00:00 |  | Name 115 | Contract115 | 1
2019-04-26 00:00:00 |  | Name 116 | Contract116 | 1
2019-04-27 00:00:00 |  | Name 117 | Contract117 | 1
2019-04-28 00:00:00 |  | Name 118 | Contract118 | 1
2019-04-29 00:00:00 |  | Name 119 | Contract119 | 1
2019-04-30 00:00:00 |  | Name 120 | Contract120 | 1
2019-05-01 00:00:00 |  | Name 121 | Contract121 | 1
2019-05-02 00:00:00 |  | Name 122 | Contract122 | 1
2019-05-03 00:00:00 |  | Name 123 | Contract123 | 1
2019-05-04 00:00:00 |  | Name 124 | Contract124 | 1
2019-05-05 00:00:00 |  | Name 125 | Contract125 | 1
2019-05-06 00:00:00 |  | Name 126 | Contract126 | 1
2019-05-07 00:00:00 |  | Name 127 | Contract127 | 1
2019-05-08 00:00:00 |  | Name 128 | Contract128 | 1
2019-05-09 00:00:00 |  | Name 129 | Contract129 | 1
2019-05-10 00:00:00 |  | Name 130 | Contract130 | 1
2019-05-11 00:00:00 |  | Name 131 | Contract131 | 1
2019-05-12 00:00:00 |  | Name 132 | Contract132 | 1
2019-05-13 00:00:00 |  | Name 133 | Contract133 | 1
2019-05-14 00:00:00 |  | Name 134 | Contract134 | 1
2019-05-15 00:00:00 |  | Name 135 | Contract135 | 1
2019-05-16 00:00:00 |  | Name 136 | Contract136 | 1
2019-05-17 00:00:00 |  | Name 137 | Contract137 | 1
2019-05-18 00:00:00 |  | Name 138 | Contract138 | 1
2019-05-19 00:00:00 |  | Name 139 | Contract139 | 1
2019-05-20 00:00:00 |  | Name 140 | Contract140 | 1
2019-05-21 00:00:00 |  | Name 141 | Contract141 | 1
2019-05-22 00:00:00 |  | Name 142 | Contract142 | 1
2019-05-23 00:00:00 |  | Name 143 | Contract143 | 1
2019-05-24 00:00:00 |  | Name 144 | Contract144 | 1
2019-05-25 00:00:00 |  | Name 145 | Contract145 | 1
2019-05-26 00:00:00 |  | Name 146 | Contract146 | 1
2019-05-27 00:00:00 |  | Name 147 | Contract147 | 1
2019-05-28 00:00:00 |  | Name 148 | Contract148 | 1
2019-05-29 00:00:00 |  | Name 149 | Contract149 | 1
2019-05-30 00:00:00 |  | Name 150 | Contract150 | 1
2019-05-31 00:00:00 |  | Name 151 | Contract151 | 1
2019-06-01 00:00:00 |  | Name 152 | Contract152 | 1
2019-06-02 00:00:00 |  | Name 153 | Contract153 | 1
2019-06-03 00:00:00 |  | Name 154 | Contract154 | 1
2019-06-04 00:00:00 |  | Name 155 | Contract155 | 1
2019-06-05 00:00:00 |  | Name 156 | Contract156 | 1
2019-06-06 00:00:00 |  | Name 157 | Contract157 | 1
2019-06-07 00:00:00 |  | Name 158 | Contract158 | 1
2019-06-08 00:00:00 |  | Name 159 | Contract159 | 1
2019-06-09 00:00:00 |  | Name 160 | Contract160 | 1
2019-06-10 00:00:00 |  | Name 161 | Contract161 | 1
2019-06-11 00:00:00 |  | Name 162 | Contract162 | 1
2019-06-12 00:00:00 |  | Name 163 | Contract163 | 1
2019-06-13 00:00:00 |  | Name 164 | Contract164 | 1
2019-06-14 00:00:00 |  | Name 165 | Contract165 | 1
2019-06-15 00:00:00 |  | Name 166 | Contract166 | 1
2019-06-16 00:00:00 |  | Name 167 | Contract167 | 1
2019-06-17 00:00:00 |  | Name 168 | Contract168 | 1
2019-06-18 00:00:00 |  | Name 169 | Contract169 | 1
2019-06-19 00:00:00 |  | Name 170 | Contract170 | 1
2019-06-20 00:00:00 |  | Name 171 | Contract171 | 1
2019-06-21 00:00:00 |  | Name 172 | Contract172 | 1
2019-06-22 00:00:00 |  | Name 173 | Contract173 | 1
2019-06-23 00:00:00 |  | Name 174 | Contract174 | 1
2019-06-24 00:00:00 |  | Name 175 | Contract175 | 1
2019-06-25 00:00:00 |  | Name 176 | Contract176 | 1
2019-06-26 00:00:00 |  | Name 177 | Contract177 | 1
2019-06-27 00:00:00 |  | Name 178 | [NAME] | 1