Spreadsheet: 750767d1633623759-expanding-on-a-formula-that-counts-unique-dates-90-calculator
Sheet: Sheet1

 |  |  |  |  |  | Payroll Register By User |  |  |  |  |  |  |  |  |  |  |  |  | # of days worked
 |  |  |  |  |  | Report Date: 06/20/2021 To 10/06/2021
 |  |  |  | Pay | Regular |  | Adj.
 | User | Employee ID | Report Date | Rate | Hours | OT Hours | Hours | Regular Pay | OT Pay | Adj. Pay |  | Total Pay | G/L Account
User:  [NAME], [NAME]
Smith, [NAME] |  |  | 6/21/2021 | 19 | 8.2 | 0 | 0 | 155.8 | 0 |  | 0 | 155.8
Smith, [NAME] |  |  | 6/22/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 6/23/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 6/24/2021 | 19 | 7.5 | 0 | 0 | 142.5 | 0 |  | 0 | 142.5
Smith, [NAME] |  |  | 6/25/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 6/26/2021 | 19 | 0.3 | 4.4 | 0 | 5.7 | 125.4 |  | 0 | 131.1
Smith, [NAME] |  |  | 6/27/2021 | 19 | 10.8 | 0 | 0 | 205.2 | 0 |  | 0 | 205.2
Smith, [NAME] |  |  | 6/28/2021 | 19 | 9.6 | 0 | 0 | 182.4 | 0 |  | 0 | 182.4
Smith, [NAME] |  |  | 6/29/2021 | 19 | 6.5 | 0 | 0 | 123.5 | 0 |  | 0 | 123.5
Smith, [NAME] |  |  | 6/30/2021 | 19 | 8.2 | 0 | 0 | 155.8 | 0 |  | 0 | 155.8
Smith, [NAME] |  |  | 7/1/2021 | 19 | 4.9 | 3.5 | 0 | 93.10000000000001 | 99.75 |  | 0 | 192.85
Smith, [NAME] |  |  | 7/2/2021 | 19 | 0 | 10.1 | 0 | 0 | 287.85 |  | 0 | 287.85
Smith, [NAME] |  |  | 7/3/2021 | 19 | 0 | 5.4 | 0 | 0 | 153.9 |  | 0 | 153.9
Smith, [NAME] |  |  | 7/4/2021 | 19 | 11.7 | 0 | 0 | 222.3 | 0 |  | 0 | 222.3
Smith, [NAME] |  |  | 7/5/2021 | 19 | 11.9 | 0 | 0 | 226.1 | 0 |  | 0 | 226.1
Smith, [NAME] |  |  | 7/6/2021 | 19 | 4.600000000000001 | 0 | 0 | 87.4 | 0 |  | 0 | 87.4
Smith, [NAME] |  |  | 7/7/2021 | 19 | 10.8 | 0 | 0 | 205.2 | 0 |  | 0 | 205.2
Smith, [NAME] |  |  | 7/8/2021 | 19 | 1 | 6.9 | 0 | 19 | 196.65 |  | 0 | 215.65
Smith, [NAME] |  |  | 7/9/2021 | 19 | 0 | 2.5 | 0 | 0 | 71.25 |  | 0 | 71.25
Smith, [NAME] |  |  | 7/12/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 7/13/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 7/14/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 7/15/2021 | 19 | 8 | 0 | 0 | 152 | 0 |  | 0 | 152
Smith, [NAME] |  |  | 7/16/2021 | 19 | 8 | 1.2 | 0 | 152 | 34.2 |  | 0 | 186.2
Smith, [NAME] |  |  | 7/18/2021 | 19 | 9.200000000000001 | 0 | 0 | 174.8 | 0 |  | 0 | 174.8
Smith, [NAME] |  |  | 7/19/2021 | 19 | 10.8 | 0 | 0 | 205.2 | 0 |  | 0 | 205.2
Smith, [NAME] |  |  | 7/20/2021 | 19 | 9.1 | 0 | 0 | 172.9 | 0 |  | 0 | 172.9
Smith, [NAME] |  |  | 7/21/2021 | 19 | 9.3 | 0 | 0 | 176.7 | 0 |  | 0 | 176.7
Smith, [NAME] |  |  | 7/22/2021 | 19 | 1.6 | 8 | 0 | 30.4 | 228 |  | 0 | 258.4
Smith, [NAME] |  |  | 7/23/2021 | 19 | 0 | 10.3 | 0 | 0 | 293.55 |  | 0 | 293.55
Smith, [NAME] |  |  | 7/24/2021 | 19 | 0 | 4.7 | 0 | 0 | 133.95 |  | 0 | 133.95
Smith, [NAME] |  |  | 7/25/2021 | 19.45 | 8 | 5 | 0 | 155.6 | 145.88 |  | 0 | 301.48
Printed: 10/7/2021 11:07:10 AM |  |  |  |  |  |  |  |  |  |  |  |  | Page
 |  |  |  |  |  | Payroll Register By User
 |  |  |  |  |  | Report Date: 06/20/2021 To 10/06/2021
 |  |  |  | Pay | Regular |  | Adj.
 | User | Employee ID | Report Date | Rate | Hours | OT Hours | Hours | Regular Pay | OT Pay | Adj. Pay |  | Total Pay | G/L Account
Smith, [NAME] |  |  | 7/26/2021 | 19.45 | 8 | 2 | 0 | 155.6 | 58.35 |  | 0 | 213.95
Smith, [NAME] |  |  | 7/27/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 7/29/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 7/30/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/1/2021 | 19.45 | 8 | 2.7 | 0 | 155.6 | 78.77 |  | 0 | 234.37
Smith, [NAME] |  |  | 8/2/2021 | 19.45 | 8 | 4 | 0 | 155.6 | 116.7 |  | 0 | 272.3
Smith, [NAME] |  |  | 8/3/2021 | 19.45 | 8 | 1.7 | 0 | 155.6 | 49.6 |  | 0 | 205.2
Smith, [NAME] |  |  | 8/5/2021 | 19.45 | 8 | 3 | 0 | 155.6 | 87.53 |  | 0 | 243.13
Smith, [NAME] |  |  | 8/6/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/8/2021 | 19.45 | 8 | 3.5 | 0 | 155.6 | 102.11 |  | 0 | 257.71
Smith, [NAME] |  |  | 8/9/2021 | 19.45 | 8 | 3.1 | 0 | 155.6 | 90.44 |  | 0 | 246.04
Smith, [NAME] |  |  | 8/10/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/12/2021 | 19.45 | 8 | 2 | 0 | 155.6 | 58.35 |  | 0 | 213.95
Smith, [NAME] |  |  | 8/13/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/15/2021 | 19.45 | 8 | 3 | 0 | 155.6 | 87.53 |  | 0 | 243.13
Smith, [NAME] |  |  | 8/16/2021 | 19.45 | 8 | 2 | 0 | 155.6 | 58.35 |  | 0 | 213.95
Smith, [NAME] |  |  | 8/17/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/19/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/20/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/22/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/23/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/24/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/26/2021 | 19.45 | 8 | 3 | 0 | 155.6 | 87.53 |  | 0 | 243.13
Smith, [NAME] |  |  | 8/27/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/29/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 8/30/2021 | 19.45 | 8 | 3.5 | 0 | 155.6 | 102.11 |  | 0 | 257.71
Smith, [NAME] |  |  | 8/31/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/2/2021 | 19.45 | 8 | 6.100000000000001 | 0 | 155.6 | 177.97 |  | 0 | 333.57
Smith, [NAME] |  |  | 9/3/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/5/2021 | 19.45 | 8 | 2 | 0 | 155.6 | 58.35 |  | 0 | 213.95
Smith, [NAME] |  |  | 9/6/2021 | 19.3 | 0 | 5.19 | 0 | 0 | 200.33 |  | 0 | 200.33
Smith, [NAME] |  |  | 9/6/2021 | 19.3 | 8 | 0 | 0 | 154.4 | 0 |  | 0 | 154.4 | Holiday
Smith, [NAME] |  |  | 9/6/2021 | 19.45 | 0 | 2.81 | 0 | 0 | 109.31 |  | 0 | 109.31
Smith, [NAME] |  |  | 9/7/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/9/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Printed: 10/7/2021 11:07:10 AM |  |  |  |  |  |  |  |  |  |  |  |  | Page
 |  |  |  |  |  | Payroll Register By User
 |  |  |  |  |  | Report Date: 06/20/2021 To 10/06/2021
 |  |  |  | Pay | Regular |  | Adj.
 | User | Employee ID | Report Date | Rate | Hours | OT Hours | Hours | Regular Pay | OT Pay | Adj. Pay |  | Total Pay | G/L Account
Smith, [NAME] |  |  | 9/10/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/12/2021 | 19.45 | 8 | 3.2 | 0 | 155.6 | 93.36 |  | 0 | 248.96
Smith, [NAME] |  |  | 9/13/2021 | 19.45 | 8 | 4.3 | 0 | 155.6 | 125.45 |  | 0 | 281.05
Smith, [NAME] |  |  | 9/14/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/16/2021 | 19.45 | 8 | 3.2 | 0 | 155.6 | 93.36 |  | 0 | 248.96
Smith, [NAME] |  |  | 9/17/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/19/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/20/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/21/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/24/2021 | 19.3 | 4.91 | 0 | 0 | 94.76 | 0 |  | 0 | 94.76
Smith, [NAME] |  |  | 9/24/2021 | 19.45 | 3.09 | 0 | 0 | 60.1 | 0 |  | 0 | 60.1
Smith, [NAME] |  |  | 9/26/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/27/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/28/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 9/30/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 10/1/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Smith, [NAME] |  |  | 10/3/2021 | 19.45 | 8 | 2 | 0 | 155.6 | 58.35 |  | 0 | 213.95
Smith, [NAME] |  |  | 10/4/2021 | 19.45 | 8 | 3 | 0 | 155.6 | 87.53 |  | 0 | 243.13
Smith, [NAME] |  |  | 10/5/2021 | 19.45 | 8 | 0 | 0 | 155.6 | 0 |  | 0 | 155.6
Subtotal: | Smith, [NAME] |  |  |  | 616 | 127.3 | 0 | 11889.26 | 3751.76 |  | 0 | 15641.02
Grand Total: |  |  |  |  | 616 | 127.3 | 0 | 11889.26 | 3751.76 |  | 0 | 15641.02
Printed: 10/7/2021 11:07:10 AM |  |  |  |  |  |  |  |  |  |  |  |  | Page