Spreadsheet: 197141d1354222969-index-or-sumproduct-for-date-index_date_issue-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-02 00:00:00 | Jan 2-8
 |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  |  |  |  |  | 2012-01-03 00:00:00 | Jan 2-8
 |  | Week 1 | Jan 2-8 | Feb 6-12 | [NAME] | Apr 2-8 | May 7-13 | [NAME] | July 2-8 | Aug 6-12 | Sep 3-9 | Oct 1-7 | Nov 5-11 | Dec 3-9 |  |  |  |  |  | 2012-01-04 00:00:00 | Jan 2-8
 |  | Week 2 | Jan 9-15 | Feb 13-19 | [NAME] | Apr 9-15 | May 14-20 | [NAME] | July 10-15 | Aug 13-19 | Sep 10-16 | Oct 8-14 | Nov 12-18 | Dec 10-16 |  |  |  |  |  | 2012-01-05 00:00:00 | Jan 2-8
 |  | Week 3 | Jan 16-22 | Feb 20-26 | [NAME] | Apr 16-22 | May 21-27 | [NAME] | July 16-22 | Aug 20-26 | Sep 17-23 | Oct 15-21 | Nov 19-25 | Dec 17-23 |  |  |  |  |  | 2012-01-06 00:00:00 | Jan 2-8
 |  | Week 4 | Jan 23-29 | Feb 27-Mar 4 | [NAME] | Apr 23-29 | May 28-Jun 3 | Jun 25-July1 | July 23-29 | Aug 27-Sep 2 | Sep 24-30 | Oct 22-28 | Nov 26-Dec 2 | Dec 24-30 |  |  |  |  |  | 2012-01-07 00:00:00 | Jan 2-8
 |  | Week 5 | Jan 30-Feb 5 |  |  | Apr 30-May 6 |  |  | July 30-Aug 5 |  |  | Oct 29-Nov 4 |  |  |  |  |  |  |  | 2012-01-08 00:00:00 | Jan 2-8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-09 00:00:00 | Jan 9-15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-10 00:00:00 | Jan 9-15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-11 00:00:00 | Jan 9-15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-12 00:00:00 | Jan 9-15
 |  | Purchased | 2012-01-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-13 00:00:00 | Jan 9-15
 |  | Commission date |  | (commission paid on 28th day from purchase date) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-14 00:00:00 | Jan 9-15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-15 00:00:00 | Jan 9-15
 |  | Falls between |  | < need formula that will select the correct time frame the date in D14 falls under |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-16 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-17 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-18 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-19 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-20 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-21 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-22 00:00:00 | Jan 16-22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-23 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-24 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-25 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-26 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-27 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-28 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-29 00:00:00 | Jan 23-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-30 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-31 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-02 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-03 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-04 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-05 00:00:00 | Jan 30-Feb 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-06 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-07 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-08 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-09 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-10 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-11 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-12 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-13 00:00:00 | Feb 6-12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-14 00:00:00 | Feb 6-12