Spreadsheet: 764435d1642739342-counting-call-off-occurrences-test-2
Sheet: Sheet1

 | 2022-01-20 00:00:00 | C=Call Off     X=Day Off      L=Leave of Absence |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  | Call offs
 |  | V=Vacation  U=Training
 | Use Delete to erase cell and not space bar! |  |  |  | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00
Day Shift Full Time |  | Employee | Start Date | Hours | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A
21-6688 | Linen Distribution | TEST 1 |  | 80 |  | X |  |  |  |  | X | X |  | C | X | C | C |  |  | X |  |  |  |  | X | X |  |  | X
 |  |  |  |  | Test 1 should have 1 call off in Column AI
 | 2022-01-20 00:00:00 | C=Call Off     X=Day Off      L=Leave of Absence |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4
 |  | V=Vacation  U=Training
 | Use Delete to erase cell and not space bar! |  |  |  | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00
Day Shift Full Time |  | Employee | Start Date | Hours | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A
21-6688 | Linen Distribution | TEST 2 |  | 80 |  | X |  |  |  |  | X | X |  | C | X |  | C | C |  | X |  |  |  |  | X | X |  |  | X
 |  |  |  |  | Test 2 should have 2 call offs in Column AI
 | 2022-01-20 00:00:00 | C=Call Off     X=Day Off      L=Leave of Absence |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4
 |  | V=Vacation  U=Training
 | Use Delete to erase cell and not space bar! |  |  |  | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00
Day Shift Full Time |  | Employee | Start Date | Hours | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A
21-6688 | Linen Distribution | TEST 3 |  | 80 |  | X |  | C | C | C | X | X | C |  | X |  |  |  |  | X |  |  |  |  | X | X |  |  | X
 |  |  |  |  | Test 3 should have 2 call offs in Column AI
 | 2022-01-20 00:00:00 | C=Call Off     X=Day Off      L=Leave of Absence |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4
 |  | V=Vacation  U=Training
 | Use Delete to erase cell and not space bar! |  |  |  | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00
Day Shift Full Time |  | Employee | Start Date | Hours | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A | S | M | T | W | R | F | A
21-6688 | Linen Distribution | TEST 4 |  | 80 |  | X |  |  |  |  | X | X |  | C | X | C | C |  | C | X |  |  |  |  | X | X |  |  | X
 |  |  |  |  | Test 4 should have 2 call offs in Column AI
 |  |  |  |  | Call off Rules
 |  |  |  |  | A call off count as an occurrence if: * It is the first day called off. * It is the fourth day called off.  Call offs before and after days off are counted as the same occurrence unless it satisfies one of the above two conditions.