Spreadsheet: 128854d1321307712-formula-for-determining-payment-dates-pivottablegroup7days2
Sheet: Sheet1

Delivery Date | Price | DOW
2011-09-13 00:00:00 | 0 |  | <<Put in a fake data that is a Thursday
2011-09-21 00:00:00 | 1 | 4
2011-09-21 00:00:00 | 9 | 4
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 |  |  | Row Labels | Sum of Price | Count of Price2
2011-09-26 00:00:00 | 23 | 2 |  |  | 9/13/2011 - 9/19/2011 | 0 | 1
2011-09-26 00:00:00 | 14 | 2 |  |  | 9/20/2011 - 9/26/2011 | 112 | 8
2011-09-27 00:00:00 | 27 | 3 |  |  | 9/27/2011 - 10/3/2011 | 217 | 12
2011-09-27 00:00:00 | 2 | 3 |  |  | 10/4/2011 - 10/10/2011 | 220 | 14
2011-09-27 00:00:00 | 28 | 3 |  |  | 10/11/2011 - 10/17/2011 | 241 | 14
2011-09-29 00:00:00 | 17 | 5 |  |  | 10/18/2011 - 10/24/2011 | 318 | 22
2011-09-29 00:00:00 | 10 | 5 |  |  | 10/25/2011 - 10/31/2011 | 172 | 12
2011-09-30 00:00:00 | 27 | 6 |  |  | 11/1/2011 - 11/7/2011 | 199 | 12
2011-10-01 00:00:00 | 18 | 7 |  |  | 11/8/2011 - 11/14/2011 | 136 | 7
2011-10-01 00:00:00 | 30 | 7 |  |  | Grand Total | 1615 | 102
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