Spreadsheet: 551612d1513046679-calculate-future-date-based-on-dates-of-past-events-book1
Sheet: 2017

 |  |  |  |  | 2017 OFF DUTY SECURITY EARNINGS
 | DATES |  |  |  |  | TIME |  |  |  |  |  | PAYROLL |  |  |  |  | DEP
 | WRKD | DAY | EST PMT | DAY | ACT PMT | EMP | LOC | BEG | END | HRS | WEEK | RATE | GROSS | DEDS | NET | MNTHLY | DATE | [NAME]
 | 2017-11-01 00:00:00 |  | 2017-11-10 00:00:00 |  | 2017-11-10 00:00:00 | RS | CHB | 7.75 | 0.25 |  |  |  |  |  |  |  | 2017-11-10 00:00:00
 | 2017-11-06 00:00:00 |  | 2017-11-17 00:00:00 |  | 2017-11-16 00:00:00 | AU | XPO | 8 | 24 |  |  |  |  |  |  |  | 2017-11-16 00:00:00
 | 2017-11-11 00:00:00 |  | 2017-11-17 00:00:00 |  | 2017-11-17 00:00:00 | RS | CSR | 16.75 | 24 |  |  |  |  |  |  |  | 2017-11-17 00:00:00
 | 2017-11-12 00:00:00 |  | 2017-11-17 00:00:00 |  | 2017-11-17 00:00:00 | RS | CHB | 8.75 | 22.75 |  |  |  |  |  |  |  | 2017-11-17 00:00:00
 | 2017-11-16 00:00:00 |  | 2017-11-24 00:00:00 |  | 2017-11-24 00:00:00 | RS | CHB | 10.75 | 22.75 |  |  |  |  |  |  |  | 2017-11-24 00:00:00
 | 2017-11-18 00:00:00 |  | 2017-12-01 00:00:00 |  | 2017-12-01 00:00:00 | AU | XPO | 8 | 24 |  |  |  |  |  |  |  | 2017-12-01 00:00:00
 | 2017-11-20 00:00:00 |  | 2017-12-01 00:00:00 |  | 2017-12-01 00:00:00 | AU | XPO | 8 | 24 |  |  |  |  |  |  |  | 2017-12-01 00:00:00 |  |  | CHB | 28 | A
 | 2017-11-24 00:00:00 |  | 2017-12-08 00:00:00 |  |  | AU | XPO | 8 | 24 |  |  |  |  |  |  |  |  |  |  | CSR | 28 | B
 | 2017-11-27 00:00:00 |  | 2017-12-08 00:00:00 |  |  | AU | XPO | 16 | 24 |  |  |  |  |  |  |  |  |  |  | FDIC | 55 | C
 | 2017-11-30 00:00:00 |  | 2017-12-08 00:00:00 |  | 2017-12-08 00:00:00 | RS | CHB | 10.75 | 23 |  |  |  |  |  |  |  | 2017-12-08 00:00:00 |  |  | GWC | 40 | CHB | 82
 | 2017-12-02 00:00:00 |  | 2017-12-08 00:00:00 |  | 2017-12-08 00:00:00 | GA | GWC | 10.5 | 21 |  |  |  |  | 34.77 |  |  | 2017-12-08 00:00:00 |  |  | MB | 35 | CSR | 102
 | 2017-12-03 00:00:00 |  | 2017-12-15 00:00:00 |  |  | GA | GWC | 8.5 | 17 |  |  |  |  |  |  |  |  |  |  | SOC | 40 | D
 | 2017-12-06 00:00:00 |  | 2017-12-15 00:00:00 |  |  | AU | XPO | 8 | 24 |  |  |  |  |  |  |  |  |  |  | VAR | 35 | F
 | 2017-12-09 00:00:00 |  | 2017-12-15 00:00:00 |  |  | GA | GWC | 7 | 21.5 |  |  |  |  |  |  |  |  |  |  | XPO | 33.5 | G
 | 2017-12-12 00:00:00 |  | 2017-12-22 00:00:00 |  |  | AU | XPO | 16 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | H
 | 2017-12-16 00:00:00 |  | 2017-12-22 00:00:00 |  |  | GA | GWC | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | I
 | 2017-12-17 00:00:00 |  | 2017-12-22 00:00:00 |  |  | RS | CHB | 9 | 22 |  |  |  |  |  |  |  |  |  |  |  |  | J
 | 2017-12-19 00:00:00 |  | 2017-12-29 00:00:00 |  |  | AU | XPO | 8 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | K
 | 2017-12-21 00:00:00 |  | 2017-12-29 00:00:00 |  |  | AU | XPO | 16 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | L
 | 2017-12-24 00:00:00 |  | 2017-12-29 00:00:00 |  |  | RS | CHB | 9 | 21 |  |  |  |  |  |  |  |  |  |  |  |  | M
 | 2017-12-26 00:00:00 |  | 2018-01-05 00:00:00 |  |  | RS | CHB | 11 | 22 |  |  |  |  |  |  |  |  |  |  |  |  | MB | 92
 | 2017-12-30 00:00:00 |  | 2018-01-05 00:00:00 |  |  | GA | GWC | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | N
 | 2017-12-31 00:00:00 |  | 2018-01-12 00:00:00 |  |  | GA | GWC | 8 | 16 |  |  |  |  |  |  |  |  |  |  |  |  | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q
 |  | AU paywk Fri thru Thu. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R
 |  | CC paykwk Sun thru Sat. |  |  |  |  |  |  |  |  |  | Qkn.: | 4830 | Pnd.: |  |  |  |  |  |  |  | S
 |  | EP paywk Sun thru Sat. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T
 |  | GA payweek Sun thru Sat. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U
 |  | RS paywk Mon thru Sun. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
 |  | PS paywk Mon thru Sun. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | XPO | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z