Spreadsheet: 128397d1320941521-excel-2007-formulas-in-drop-down-list-copy-of-2011ptocal
Sheet: Sheet1

 |  | Employee Name
 |  | Employee ID:
 |  | Employee Type
 |  | Time Off Balances
 |  | Vacation |  |  |  | Personal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Type
 |  | 115 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Permanent Employee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Employee
 | January | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  |  | JULY | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  |  |  |  |  |  |  |  |  |  | 1
 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  |  |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  |  |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  |  |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
 |  | 29 |  | 30 |  | 31 |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 30 |  | 31
 | February | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  |  | August | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4
 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  |  |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  |  |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  |  |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25
 |  | 26 |  | 27 |  | 28 |  | 29 |  |  |  |  |  |  |  |  |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31
 | March | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  |  | September | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15
 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22
 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29
 | April | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  |  |  | 30
 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  |  | October | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20
 |  | 29 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27
 | May | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  |  |  | 28 |  | 29 |  | 30 |  | 31
 |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  |  | November | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 3
 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17
 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24
 | June | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  |  |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 2
 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  |  | December | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22 |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15
 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21 |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 31