Spreadsheet: 878642d1725877928-remove-count-of-days-when-a-conditional-yes-is-present-example
Sheet: 24 Pay Periods (Hourly)

 | CLAIM NUMBER:
 | CLAIMANT NAME:
 | HIRE DATE:
 | COMPANY NAME: |  |  |  |  |  |  |  | Note:  Only white cells can be typed in.  [NAME] cells have formulas and are protected.
 | DATE OF INJURY:
 | 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-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 40 | 1000 | 100 | 100 | 100 | 100 |  |  | No |  |  |  | Yes
 | 2 | 2024-02-01 00:00:00 | 2024-02-15 00:00:00 |  | 40 | 500 |  |  |  |  |  |  | Yes |  |  |  | No
 | 3 | 2024-02-16 00:00:00 | 2024-02-28 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 4 | 2024-03-01 00:00:00 | 2024-03-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 5 | 2024-03-16 00:00:00 | 2024-03-31 00:00:00 |  | 40 | 500 |  |  |  |  |  |  | Yes
 | 6 | 2024-04-01 00:00:00 | 2024-04-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 7 | 2024-04-16 00:00:00 | 2024-04-30 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 8 | 2024-05-01 00:00:00 | 2024-05-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 9 | 2024-05-16 00:00:00 | 2024-05-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 10 | 2024-06-01 00:00:00 | 2024-06-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 11 | 2024-06-16 00:00:00 | 2024-06-30 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 12 | 2024-07-01 00:00:00 | 2024-07-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 13 | 2024-07-16 00:00:00 | 2024-07-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 14 | 2024-08-01 00:00:00 | 2024-08-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 15 | 2024-08-16 00:00:00 | 2024-08-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 16 | 2024-09-01 00:00:00 | 2024-09-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 17 | 2024-09-30 00:00:00 | 2024-10-01 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 18 | 2024-10-15 00:00:00 | 2024-10-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 19 | 2024-11-01 00:00:00 | 2024-11-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 20 | 2024-11-16 00:00:00 | 2024-11-30 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 21 | 2024-12-01 00:00:00 | 2024-12-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 22 | 2024-12-16 00:00:00 | 2024-12-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 23 | 2025-01-01 00:00:00 | 2025-01-15 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 | 24 | 2025-01-16 00:00:00 | 2025-01-31 00:00:00 |  | 40 | 1000 |  |  |  |  |  |  | No
 |  |  |  |  | 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