Spreadsheet: 90479d1290185711-leave-calculator-can-i-highlight-payperiod-im-on-leave-calculator-example
Sheet: Sheet1

Pay Period | Your 2010 2-Week Pay Periods BEGIN |  |  | NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  | SICK LEAVE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Balance: |  |  | Balance:
 |  |  |  | For each day, enter annual leave in the left side of the box and sick leave in the right side. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAY GP
 |  |  |  | SUN | MON |  | TUE |  | WED |  | THU |  | PAY |  | SAT | SUN | MON |  | TUE |  | WED |  | THU |  | FRI |  | SAT | Earned | Used | Balance | Earned | Used | Balance
1 | 2010-01-03 00:00:00 | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  | 4 |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4
 |  | - |  |  | M | M | T | T | W | W | T | T | F | F |  |  | M | M | T | T | W | W | T | T | F | F |  |  |  |  | 4