Spreadsheet: 688781d1595953154-adding-all-purchases-from-a-custom-date-range-from-a-purchase-journal-pj-sample-excel
Sheet: Sheet3

2020 FISCAL DATES |  |  |  |  |  |  |  |  | week 1 |  | week 2 |  | week 3 |  | week 4 |  | week 5 |  | week 6
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 |  | PERIOD | begin | end | begin | end | begin | end | begin | end | begin | end | begin | end
1 | 1/1-1/5 | 1/6-1/12 | 1/13-1/19 | 1/20-1/26 | 1/27-1/31 |  |  | 1 | 2020-01-01 00:00:00 | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-12 00:00:00 | 2020-01-13 00:00:00 | 2020-01-19 00:00:00 | 2020-01-20 00:00:00 | 2020-01-26 00:00:00 | 2020-01-27 00:00:00 | 2020-01-31 00:00:00
2 | 2/1-1/2 | 2/3-2/9 | 2/10-2/16 | 2/17-2/23 | 2/24-2/29 |  |  | 2 | 2020-02-01 00:00:00 | 2020-02-02 00:00:00 | 2020-02-03 00:00:00 | 2020-02-09 00:00:00 | 2020-02-10 00:00:00 | 2020-02-16 00:00:00 | 2020-02-17 00:00:00 | 2020-02-23 00:00:00 | 2020-02-24 00:00:00 | 2020-02-29 00:00:00
3 | 3/1-3-1 | 3/2-3/8 | 3/9-3/15 | 3/16-3/22 | 3/23-3/29 | 3/30-3/31 |  | 3 | 2020-03-01 00:00:00 | 2020-03-01 00:00:00 | 2020-03-02 00:00:00 | 2020-03-08 00:00:00 | 2020-03-09 00:00:00 | 2020-03-15 00:00:00 | 2020-03-16 00:00:00 | 2020-03-22 00:00:00 | 2020-03-23 00:00:00 | 2020-03-29 00:00:00 | 2020-03-30 00:00:00 | 2020-03-31 00:00:00
4 | 4/1-4/5 | 4/6-4/12 | 4/13-4-19 | 4/20-4/26 | 4/27-4/30 |  |  | 4 | 2020-04-01 00:00:00 | 2020-04-05 00:00:00 | 2020-04-06 00:00:00 | 2020-04-12 00:00:00 | 2020-04-13 00:00:00 | 2020-04-19 00:00:00 | 2020-04-20 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-30 00:00:00
5 | 5/1-5/3 | 5/4-5/10 | 5/11-5/17 | 5/18-5/24 | 5/25-5/31 |  |  | 5 | 2020-05-01 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 1901-05-31 00:00:00 | 2020-05-18 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-31 00:00:00
6 | 6/1-6/7 | 6/8-6/14 | 6/15-6/21 | 6/22-6/28 | 6/29-6/30 |  |  | 6 | 2020-06-01 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
7 | 7/1-7/5 | 7/6-7/12 | 7/13-7/19 | 7/20-7/26 | 7/27-7/31 |  |  | 7 | 2020-07-01 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-26 00:00:00 | 2020-07-27 00:00:00 | 2020-07-31 00:00:00
8 | 8/1-8/2 | 8/3-8/9 | 8/10-8/16 | 8/17-8/23 | 8/24-8/30 | 8/31-8/31 |  | 8 | 2020-08-01 00:00:00 | 2020-08-02 00:00:00 | 2020-08-03 00:00:00 | 2020-08-09 00:00:00 | 2020-08-10 00:00:00 | 2020-08-16 00:00:00 | 2020-08-17 00:00:00 | 2020-08-23 00:00:00 | 2020-08-24 00:00:00 | 2020-08-30 00:00:00 | 2020-08-31 00:00:00 | 2020-08-31 00:00:00
9 | 9/1-9/6 | 9/7-9/13 | 9/14-9/20 | 9/21-9/27 | 9/28-9/30 |  |  | 9 | 2020-09-01 00:00:00 | 2020-09-06 00:00:00 | 2020-09-07 00:00:00 | 2020-09-13 00:00:00 | 2020-09-14 00:00:00 | 2020-09-20 00:00:00 | 2020-09-21 00:00:00 | 2020-09-27 00:00:00 | 2020-09-28 00:00:00 | 2020-09-30 00:00:00
10 | 10/1-10/4 | 10/5-10/11 | 10/12-10/18 | 10/19-10/25 | 10/26-10/31 |  |  | 10 | 2020-10-01 00:00:00 | 2020-10-04 00:00:00 | 2020-10-05 00:00:00 | 2020-10-11 00:00:00 | 2020-10-12 00:00:00 | 2020-10-18 00:00:00 | 2020-10-19 00:00:00 | 2020-10-25 00:00:00 | 2020-10-26 00:00:00 | 2020-10-31 00:00:00
11 | 11/1-11/1 | 11/2-11/8 | 11/9-11/15 | 11/16-11/22 | 11/23-11/29 | 11/30-11/30 |  | 11 | 2020-11-01 00:00:00 | 2020-11-01 00:00:00 | 2020-11-02 00:00:00 | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-22 00:00:00 | 2020-11-23 00:00:00 | 2020-11-29 00:00:00 | 2020-11-30 00:00:00 | 2020-11-30 00:00:00
12 | 12/1-12/6 | 12/7-12/13 | 12/14-12/20 | 12/21-12/27 | 12-28-12/31 |  |  | 12 | 2020-12-01 00:00:00 | 2020-12-06 00:00:00 | 2020-12-07 00:00:00 | 2020-12-13 00:00:00 | 2020-12-14 00:00:00 | 2020-12-20 00:00:00 | 2020-12-21 00:00:00 | 2020-12-27 00:00:00 | 2020-12-28 00:00:00 | 2020-12-31 00:00:00
2020 SALES
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | PERIOD TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
 |  |  |  |  |  |  | YEAR TOTAL
2020 PURCHASES
PERIOD | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 6 | PERIOD TOTAL
1
2
3
4
5
6
7
8
9
10
11
12
 |  |  |  |  |  |  | YEAR TOTAL