Spreadsheet: 888223d1738693932-formula-calculating-wrong-number-of-days-example-sheet
Sheet: 24 Pay Periods (Hourly)

 | CLAIM NUMBER: |  | 11111
 | CLAIMANT NAME: |  | [NAME]
 | HIRE DATE: |  | 2024-02-09 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-23 00:00:00
 | EARNED INCOME CAPACITY:
 | 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-02-01 00:00:00 | 2024-02-15 00:00:00 |  | 30.2 | 634.2 | 29.3 |  | 21 |  |  |  | Yes |  |  |  | Yes
 | 2 | 2024-02-16 00:00:00 | 2024-02-29 00:00:00 |  | 75 | 1575 | 320.67 |  | 10 | 63 |  |  | No |  |  |  | No
 | 3 | 2024-03-01 00:00:00 | 2024-03-15 00:00:00 |  | 64.45 | 1353.45 | 489.83 |  | 84 | 57.96 |  |  | No
 | 4 | 2024-03-16 00:00:00 | 2024-03-31 00:00:00 |  | 71.53 | 1502.13 | 189.63 |  | 10 | 42 |  |  | No
 | 5 | 2024-04-01 00:00:00 | 2024-04-15 00:00:00 |  | 81.89 | 1719.69 | 473.13 |  | 84 | 28.14 |  |  | No
 | 6 | 2024-04-16 00:00:00 | 2024-04-30 00:00:00 |  | 76.3 | 1602.3 | 386.51 |  | 94 | 24.36 |  |  | No
 | 7 | 2024-05-01 00:00:00 | 2024-05-15 00:00:00 |  | 68.32 | 1434.72 | 131.99 |  | 21 |  |  |  | No
 | 8 | 2024-05-16 00:00:00 | 2024-05-31 00:00:00 |  | 73.25 | 1538.25 |  |  | 178 | 59.85 |  |  | No
 | 9 | 2024-06-01 00:00:00 | 2024-06-15 00:00:00 |  | 67.08 | 1408.68 | 87.57 |  |  | 21 |  |  | No
 | 10 | 2024-06-16 00:00:00 | 2024-06-30 00:00:00 |  | 66.61 | 1398.81 | 206.64 |  | 10 | 42 |  |  | No
 | 11 | 2024-07-01 00:00:00 | 2024-07-15 00:00:00 |  | 59.94 | 1258.74 | 217.98 |  |  | 168 |  |  | No
 | 12 | 2024-07-16 00:00:00 | 2024-07-31 00:00:00 |  | 62.86 | 1320.06 | 144.9 |  | 10 | 126 |  |  | No
 | 13 | 2024-08-01 00:00:00 | 2024-08-15 00:00:00 |  | 73.78 | 1549.38 | 258.3 |  |  | 168 |  |  | No
 | 14 | 2024-08-16 00:00:00 | 2024-08-31 00:00:00 |  | 75.87 | 1593.27 | 71.82 |  |  | 10 |  |  | No
 | 15 | 2024-09-01 00:00:00 | 2024-09-15 00:00:00 |  | 57.89 | 1215.69 | 209.48 |  | 168 |  |  |  | No
 | 16 | 2024-09-16 00:00:00 | 2024-09-30 00:00:00 |  | 70.89 | 1488.69 | 148.37 |  | 31 | 168 |  |  | No
 | 17 | 2024-10-01 00:00:00 | 2024-10-15 00:00:00 |  | 85.65 | 1798.65 | 482.27 |  | 42 | 30.66 |  |  | No
 | 18 | 2024-10-16 00:00:00 | 2024-10-31 00:00:00 |  | 87.66 | 1840.86 | 276.57 |  | 10 | 21 |  |  | No
 | 19 | 2024-11-01 00:00:00 | 2024-11-15 00:00:00 |  | 75.74 | 1590.54 | 200.03 |  |  | 38.64 |  |  | No
 | 20 | 2024-11-16 00:00:00 | 2024-11-30 00:00:00 |  | 55.52 | 1165.92 | 245.39 |  | 336 | 31 |  |  | No
 | 21 | 2024-12-01 00:00:00 | 2024-12-15 00:00:00 |  | 70.03 | 1470.63 | 375.8 | 168 | 21 | 25.2 |  |  | No
 | 22 | 2024-12-16 00:00:00 | 2024-12-31 00:00:00 |  | 78.2 | 1642.2 | 222.39 | 168 | 10 | 168 |  |  | No
 | 23 | 2025-01-01 00:00:00 | 2025-01-15 00:00:00 |  | 51.72 | 1086.12 | 348.08 | 168 | 42 | 45.36 |  |  | No
 | 24 | 2025-01-16 00:00:00 | 2025-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  | 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