Spreadsheet: 861390d1709261001-looking-for-ways-to-calculate-work-weeks-sample-workweeks-book-1-1-
Sheet: Sheet1

First Day of Pay Period (Sunday) | Last Day of 1st Week Of Pay Period (Friday) | Last Day of Pay Period (Saturday) | Pay Period | Name | ID # | Day Worked |  |  |  | Work Weeks (Weeks where person has worked at least one day) | Weeks Worked Between 10/14/2018 and 11/25/2018
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-09 00:00:00 |  |  | 1234
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-10 00:00:00 |  | 201841 | 1235 | 2 | 2
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-11 00:00:00 |  | 201841 | 1236 | 2 | 1
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-12 00:00:00 |  | 201841
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-16 00:00:00 |  | 201842
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-17 00:00:00 |  | 201842
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-18 00:00:00 |  | 201842
2018-10-07 00:00:00 | 2018-10-12 00:00:00 | 2018-10-20 00:00:00 | 2018-10-26 00:00:00 | [NAME] | 1234 | 2018-10-19 00:00:00 |  | 201842
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-23 00:00:00 |  | 201843
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-24 00:00:00 |  | 201843
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-25 00:00:00 |  | 201843
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-26 00:00:00 |  | 201843
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-30 00:00:00 |  | 201844
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-10-31 00:00:00 |  | 201844
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-11-01 00:00:00 |  | 201844
2018-10-21 00:00:00 | 2018-10-26 00:00:00 | 2018-11-03 00:00:00 | 2018-11-09 00:00:00 | [NAME] | 1234 | 2018-11-02 00:00:00 |  | 201844
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-06 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-07 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-08 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-09 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-13 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-14 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-15 00:00:00 |  | #N/A
2018-11-04 00:00:00 | 2018-11-09 00:00:00 | 2018-11-17 00:00:00 | 2018-11-23 00:00:00 | Melvin the Magus | 1235 | 2018-11-16 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-20 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-21 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-22 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-23 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-27 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-28 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-29 00:00:00 |  | #N/A
2018-11-18 00:00:00 | 2018-11-23 00:00:00 | 2018-12-01 00:00:00 | 2018-12-07 00:00:00 | [NAME] | 1236 | 2018-11-30 00:00:00 |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  | #N/A