Spreadsheet: 888820d1739400896-formula-calculating-wrong-number-of-days-example
Sheet: 24 Pay Periods (Hourly)

 | CLAIM NUMBER: |  | 11111
 | CLAIMANT NAME: |  | [NAME]
 | HIRE DATE: |  | 2020-06-04 00:00:00
 | COMPANY NAME: |  | ABC Company |  |  |  |  |  | Note:  Only white cells can be typed in.  [NAME] cells have formulas and are protected.
 | DATE OF INJURY: |  | 2025-01-26 00:00:00
 | EARNED INCOME CAPACITY: |  | 20
 | PAY               PERIOD | PAY PERIOD START DATE | PAY PERIOD END DATE | HOURLY          RATE | HOURS WORKED | REGULAR PAY EARNED | OVERTIME PAY EARNED | HOLIDAY PAY EARNED | BONUS PAY EARNED | OTHER PAY EARNED | TOTAL PAY EARNED | TOTAL PAY (EIC USED) | EXCLUDE PAY PERIOD                 (Yes or No) | PAY USED FOR AVERAGE WEEKLY WAGE (NO EIC) | PAY USED FOR AVG WEEKLY WAGE            (EIC USED) | REASON PAY PERIOD EXCLUDED
 | 1 | 2024-01-01 00:00:00 | 2024-01-15 00:00:00 |  | 60.68 | 1152.92 | 6.84 | 304 | 0 |  |  |  | Yes |  |  | pay period is greater than 1 year pre-injury | Yes
 | 2 | 2024-01-16 00:00:00 | 2024-01-31 00:00:00 |  | 83.48 | 1586.12 | 8.84 |  |  | 5 |  |  | Yes |  |  | pay period is greater than 1 year pre-injury | No
 | 3 | 2024-02-01 00:00:00 | 2024-02-15 00:00:00 |  | 65.9 | 1252.1 | 31.07 |  |  | 152 |  |  | No
 | 4 | 2024-02-16 00:00:00 | 2024-02-29 00:00:00 |  | 78.03 | 1482.57 | 6.84 |  |  | 5 |  |  | No
 | 5 | 2024-03-01 00:00:00 | 2024-03-15 00:00:00 |  | 80 | 1520 | 220.02 |  |  |  |  |  | No
 | 6 | 2024-03-16 00:00:00 | 2024-03-31 00:00:00 |  | 39.98 | 759.62 | 7.98 |  |  | 5 |  |  | Yes |  |  | atypically low hours
 | 7 | 2024-04-01 00:00:00 | 2024-04-15 00:00:00 |  | 0 | 0 |  |  |  | 912 |  |  | Yes |  |  | no regular hours worked
 | 8 | 2024-04-16 00:00:00 | 2024-04-30 00:00:00 |  | 56 | 1064 | 10.55 |  |  | 461 |  |  | No
 | 9 | 2024-05-01 00:00:00 | 2024-05-15 00:00:00 |  | 71.5 | 1358.5 | 6.84 |  |  | 304 |  |  | No
 | 10 | 2024-05-16 00:00:00 | 2024-05-31 00:00:00 |  | 86.37 | 1641.03 | 13.68 |  |  | 157 |  |  | No
 | 11 | 2024-06-01 00:00:00 | 2024-06-15 00:00:00 |  | 71.96 | 1367.24 | 6.84 |  |  |  |  |  | No
 | 12 | 2024-06-16 00:00:00 | 2024-06-30 00:00:00 |  | 48 | 912 | 8.27 |  |  | 309 |  |  | No
 | 13 | 2024-07-01 00:00:00 | 2024-07-15 00:00:00 |  | 55.98 | 1063.62 | 7.7 | 152 |  | 152 |  |  | No
 | 14 | 2024-07-16 00:00:00 | 2024-07-31 00:00:00 |  | 80 | 1520 | 11.97 |  |  | 5 |  |  | No
 | 15 | 2024-08-01 00:00:00 | 2024-08-15 00:00:00 |  | 79.77 | 1515.63 | 6.84 |  |  |  |  |  | No
 | 16 | 2024-08-16 00:00:00 | 2024-08-31 00:00:00 |  | 64.55 | 1226.45 | 5.13 |  |  | 5 |  |  | No
 | 17 | 2024-09-01 00:00:00 | 2024-09-15 00:00:00 |  | 53.19 | 1063.8 | 5.7 | 160 |  | 20 |  |  | No
 | 18 | 2024-09-16 00:00:00 | 2024-09-30 00:00:00 |  | 73.9 | 1478 | 15.3 |  |  | 165 |  |  | No
 | 19 | 2024-10-01 00:00:00 | 2024-10-15 00:00:00 |  | 64 | 1280 | 8.1 |  |  | 320 |  |  | No
 | 20 | 2024-10-16 00:00:00 | 2024-10-31 00:00:00 |  | 91.39 | 1827.8 | 17.1 |  |  | 17 |  |  | No
 | 21 | 2024-11-01 00:00:00 | 2024-11-15 00:00:00 |  | 62.47 | 1249.4 | 6.6 |  |  |  |  |  | No
 | 22 | 2024-11-16 00:00:00 | 11/31/24 |  | 61.77 | 1235.4 | 70.8 | 320 |  | 5 |  |  | No
 | 23 | 2024-12-01 00:00:00 | 2024-12-15 00:00:00 |  | 71.2 | 1424 | 25.5 |  |  | 160 |  |  | No
 | 24 | 2024-12-16 00:00:00 | 2024-12-31 00:00:00 |  | 0 | 0 |  |  |  |  |  |  | Yes |  |  | no data provided
 |  |  |  |  | TOTAL HOURS WORKED | TOTAL REGULAR PAY | TOTAL             OT PAY | TOTAL HOLIDAY PAY | TOTAL BONUS PAY | TOTAL OTHER PAY | TOTAL                      PAY | TOTAL PAY (EIC USED) | # OF PAY PERIODS INCLUDED | TOTAL WAGES USED FOR AVERAGE WEEKLY WAGE (NO EIC) | TOTAL WAGES USED FOR AVERAGE WEEKLY WAGE (EIC USED)
 |  |  |  |  |  |  |  |  |  |  |  | AVERAGE WEEKLY WAGE (NO EIC)
 |  |  |  |  |  |  |  |  |  |  |  | AVERAGE WEEKLY WAGE (EIC USED)
 |  |  |  |  |  |  |  |  |  |  |  | TEMPORARY WEEKLY DISABILITY RATE