Spreadsheet: 128850d1321306643-formula-for-determining-payment-dates-pivottablegroup7days
Sheet: Sheet1

Delivery Date | Price | DOW
2011-09-15 00:00:00 | 9
2011-09-15 00:00:00 | 18 | 5
2011-09-15 00:00:00 | 14 | 5
2011-09-16 00:00:00 | 30 | 6
2011-09-16 00:00:00 | 3 | 6
2011-09-16 00:00:00 | 9 | 6 |  |  | Row Labels | Sum of Price
2011-09-17 00:00:00 | 28 | 7 |  |  | 9/15/2011 - 9/21/2011 | 272
2011-09-17 00:00:00 | 20 | 7 |  |  | 9/22/2011 - 9/28/2011 | 183
2011-09-18 00:00:00 | 1 | 1 |  |  | 9/29/2011 - 10/5/2011 | 251
2011-09-18 00:00:00 | 22 | 1 |  |  | 10/6/2011 - 10/12/2011 | 215
2011-09-18 00:00:00 | 22 | 1 |  |  | 10/13/2011 - 10/19/2011 | 155
2011-09-18 00:00:00 | 28 | 1 |  |  | 10/20/2011 - 10/26/2011 | 381
2011-09-19 00:00:00 | 15 | 2 |  |  | 10/27/2011 - 11/2/2011 | 242
2011-09-19 00:00:00 | 4 | 2 |  |  | 11/3/2011 - 11/9/2011 | 66
2011-09-19 00:00:00 | 6 | 2 |  |  | 11/10/2011 - 11/14/2011 | 136
2011-09-20 00:00:00 | 25 | 3 |  |  | Grand Total | 1901
2011-09-20 00:00:00 | 8 | 3
2011-09-21 00:00:00 | 1 | 4
2011-09-21 00:00:00 | 9 | 4
2011-09-22 00:00:00 | 6 | 5
2011-09-22 00:00:00 | 18 | 5
2011-09-23 00:00:00 | 25 | 6
2011-09-24 00:00:00 | 13 | 7
2011-09-25 00:00:00 | 24 | 1
2011-09-26 00:00:00 | 3 | 2
2011-09-26 00:00:00 | 23 | 2
2011-09-26 00:00:00 | 14 | 2
2011-09-27 00:00:00 | 27 | 3
2011-09-27 00:00:00 | 2 | 3
2011-09-27 00:00:00 | 28 | 3
2011-09-29 00:00:00 | 17 | 5
2011-09-29 00:00:00 | 10 | 5
2011-09-30 00:00:00 | 27 | 6
2011-10-01 00:00:00 | 18 | 7
2011-10-01 00:00:00 | 30 | 7
2011-10-02 00:00:00 | 1 | 1
2011-10-02 00:00:00 | 26 | 1
2011-10-03 00:00:00 | 18 | 2
2011-10-03 00:00:00 | 13 | 2
2011-10-04 00:00:00 | 23 | 3
2011-10-04 00:00:00 | 30 | 3
2011-10-05 00:00:00 | 20 | 4
2011-10-05 00:00:00 | 18 | 4
2011-10-06 00:00:00 | 22 | 5
2011-10-07 00:00:00 | 2 | 6
2011-10-07 00:00:00 | 19 | 6
2011-10-07 00:00:00 | 1 | 6
2011-10-07 00:00:00 | 9 | 6
2011-10-07 00:00:00 | 2 | 6
2011-10-08 00:00:00 | 5 | 7
2011-10-08 00:00:00 | 26 | 7
2011-10-08 00:00:00 | 21 | 7
2011-10-10 00:00:00 | 22 | 2
2011-10-12 00:00:00 | 23 | 4
2011-10-12 00:00:00 | 20 | 4
2011-10-12 00:00:00 | 14 | 4
2011-10-12 00:00:00 | 29 | 4
2011-10-13 00:00:00 | 13 | 5
2011-10-13 00:00:00 | 10 | 5
2011-10-13 00:00:00 | 14 | 5
2011-10-13 00:00:00 | 28 | 5
2011-10-14 00:00:00 | 7 | 6
2011-10-15 00:00:00 | 29 | 7
2011-10-15 00:00:00 | 12 | 7
2011-10-15 00:00:00 | 4 | 7
2011-10-16 00:00:00 | 13 | 1
2011-10-16 00:00:00 | 25 | 1
2011-10-20 00:00:00 | 17 | 5
2011-10-20 00:00:00 | 20 | 5
2011-10-20 00:00:00 | 30 | 5
2011-10-20 00:00:00 | 1 | 5
2011-10-21 00:00:00 | 5 | 6
2011-10-21 00:00:00 | 8 | 6
2011-10-21 00:00:00 | 19 | 6
2011-10-21 00:00:00 | 15 | 6
2011-10-21 00:00:00 | 4 | 6
2011-10-21 00:00:00 | 1 | 6
2011-10-21 00:00:00 | 8 | 6
2011-10-22 00:00:00 | 1 | 7
2011-10-22 00:00:00 | 2 | 7
2011-10-22 00:00:00 | 22 | 7
2011-10-23 00:00:00 | 17 | 1
2011-10-23 00:00:00 | 16 | 1
2011-10-24 00:00:00 | 29 | 2
2011-10-24 00:00:00 | 21 | 2
2011-10-24 00:00:00 | 22 | 2
2011-10-24 00:00:00 | 16 | 2
2011-10-24 00:00:00 | 29 | 2
2011-10-24 00:00:00 | 15 | 2
2011-10-25 00:00:00 | 27 | 3
2011-10-25 00:00:00 | 11 | 3
2011-10-25 00:00:00 | 11 | 3
2011-10-26 00:00:00 | 14 | 4
2011-10-27 00:00:00 | 30 | 5
2011-10-28 00:00:00 | 10 | 6
2011-10-28 00:00:00 | 16 | 6
2011-10-29 00:00:00 | 17 | 7
2011-10-29 00:00:00 | 11 | 7
2011-10-30 00:00:00 | 2 | 1
2011-10-30 00:00:00 | 20 | 1
2011-10-30 00:00:00 | 3 | 1
2011-11-01 00:00:00 | 9 | 3
2011-11-02 00:00:00 | 30 | 4
2011-11-02 00:00:00 | 29 | 4
2011-11-02 00:00:00 | 17 | 4
2011-11-02 00:00:00 | 20 | 4
2011-11-02 00:00:00 | 28 | 4
2011-11-03 00:00:00 | 7 | 5
2011-11-03 00:00:00 | 2 | 5
2011-11-03 00:00:00 | 7 | 5
2011-11-04 00:00:00 | 12 | 6
2011-11-06 00:00:00 | 10 | 1
2011-11-07 00:00:00 | 28 | 2
2011-11-10 00:00:00 | 8 | 5
2011-11-11 00:00:00 | 5 | 6
2011-11-11 00:00:00 | 28 | 6
2011-11-12 00:00:00 | 24 | 7
2011-11-12 00:00:00 | 22 | 7
2011-11-12 00:00:00 | 28 | 7
2011-11-13 00:00:00 | 21 | 1