Spreadsheet: 125845d1319277929-compute-weekly-values-from-the-monthly-data-sales-monitoring_sample
Sheet: JulySales

 | Daily Total | Day | Date | Sale_Emp1 | Sale_Emp2 |  |  | Week number | Emp1 | Emp2
September |  |  |  |  |  |  |  | Week 1 = first Monday up to Saturday of the month, then week 2 = 2nd Monday up to 2nd Saturday, then so on.  Can I dynamically get the dates of the first week based on the given Day/Date values in column C and D? Since days are not constant (e.g  this year Sep1 is Thursday but next year it's Saturday). | Once I've already determined the dates of the first week, I would like to get the total number of sale for each week (from Monday to Saturday) | Once I've already determined the dates of the first week, I would like to get the total number of sale for each week (from Monday to Saturday)
 |  |  | 2011-09-01 00:00:00 | 215 | 216 |  | Week1 = | 5-Sep to 10-Sep (<<== need a formula to get this value) | 1117 (need a formula to get the sum of E9:E14) | 1154 (the sum of F9:F14)
 |  |  | 2011-09-02 00:00:00 | 181 | 187 |  | Week2 = | 12-Sep to 17-Sep (<<== need a formula to get this value) | 1178 (the sum of E15:E20) | (… and so on)
 |  |  | 2011-09-03 00:00:00 | 171 | 127 |  | Week3 = | 19-Sep to 24-Sep  (<<== need a formula to get this value) | (… and so on) | (… and so on)
 |  |  | 2011-09-05 00:00:00 | 124 | 145 |  | Week4 = | 22-Aug to 27-Aug  (<<== need a formula to get this value) | (… and so on) | (… and so on)
 |  |  | 2011-09-06 00:00:00 | 190 | 220 |  | Week5 = | 27-Sep to 1-Oct  (<<== need a formula to get this value) | (… and so on) | (… and so on)
 |  |  | 2011-09-07 00:00:00 | 201 | 237 |  | Week6 = | 3-Oct to 8-Oct  (<<== need a formula to get this value) | (… and so on) | (… and so on)
 |  |  | 2011-09-08 00:00:00 | 200 | 165 |  | Weekn = | (… and so on) | (… and so on) | (… and so on)
 |  |  | 2011-09-09 00:00:00 | 206 | 160
 |  |  | 2011-09-10 00:00:00 | 196 | 227
 |  |  | 2011-09-12 00:00:00 | 191 | 220
 |  |  | 2011-09-13 00:00:00 | 191 | 173
 |  |  | 2011-09-14 00:00:00 | 190 | 272
 |  |  | 2011-09-15 00:00:00 | 201 | 222
 |  |  | 2011-09-16 00:00:00 | 215 | 167
 |  |  | 2011-09-17 00:00:00 | 190 | 188
 |  |  | 2011-09-19 00:00:00 | 176 | 155
 |  |  | 2011-09-20 00:00:00 | 193 | 258
 |  |  | 2011-09-21 00:00:00 | 201 | 217
 |  |  | 2011-09-22 00:00:00 | 202 | 222
 |  |  | 2011-09-23 00:00:00 | 210 | 193
 |  |  | 2011-09-24 00:00:00 | 192 | 236
 |  |  | 2011-09-26 00:00:00 | 168 | 184
 |  |  | 2011-09-27 00:00:00 | 178 | 215
 |  |  | 2011-09-28 00:00:00 | 170 | 157
 |  |  | 2011-09-29 00:00:00 | 193 | 223
 |  |  | 2011-09-30 00:00:00 | 209 | 219
October |  |  | 2011-10-01 00:00:00 | 222 | 184
 |  |  | 2011-10-03 00:00:00 | 196 | 161
 |  |  | 2011-10-04 00:00:00 | 174 | 219
 |  |  | 2011-10-05 00:00:00 | 221 | 249
 |  |  | 2011-10-06 00:00:00 | 210 | 227
 |  |  | 2011-10-07 00:00:00 | 195 | 197
 |  |  | 2011-10-08 00:00:00 | 178 | 237
 |  |  | 2011-10-10 00:00:00 | 201 | 180
 |  |  | 2011-10-11 00:00:00 | 218 | 227
 |  |  | 2011-10-12 00:00:00 | 213 | 291
 |  |  | 2011-10-13 00:00:00 | 211 | 218
 |  |  | 2011-10-14 00:00:00 | 203 | 163
 |  |  | 2011-10-15 00:00:00 | 178 | 197
 |  |  | 2011-10-17 00:00:00 | 222 | 238
 |  |  | 2011-10-18 00:00:00 | 233 | 228
 |  |  | 2011-10-19 00:00:00 | 224 | 222
 |  |  | 2011-10-20 00:00:00 | 221 | 241
 |  |  | 2011-10-21 00:00:00 | 217 | 221
 |  |  | 2011-10-22 00:00:00 | 193 | 156
 |  |  | 2011-10-24 00:00:00 | 208 | 217
 |  |  | 2011-10-25 00:00:00 | 201 | 202
 |  |  | 2011-10-26 00:00:00 | 230 | 200
 |  |  | 2011-10-27 00:00:00 | 79 | 82
 |  |  | 2011-10-28 00:00:00 | 238 | 189
 |  |  | 2011-10-29 00:00:00 | 227 | 214
 |  |  | 2011-10-31 00:00:00 | 202 | 179