Spreadsheet: 295500d1391712567-creating-a-time-off-tracker-for-work-and-i-am-at-a-total-loss-track
Sheet: Output

2014 Week Ending Dates |  | Sat - WE |  | January |  | February |  |  | Leap Year? |  | March |  |  |  | April |  |  |  | May |  |  |  |  |  | June |  |  | July |  |  |  |  | August |  |  |  | September |  |  |  | October |  |  |  | November |  |  |  |  | December
 | PTO Hrs | 2014-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-05-03 00:00:00
IS Managers
[NAME] | 280 (120) | 12/30/2013 - 1/3/2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-12-26 00:00:00 | 12/29 - 1/2
[NAME] | 320 (120) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/3 - 7/4 | VACATION | (vaca tentitive) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12/22 - 12/26
employee q | 280 (120) |  |  |  |  | 2014-01-31 00:00:00 |  |  |  | 2014-02-28 00:00:00 | 3/4 3/5 3/6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6/26 & 6/27 | VACATION
[NAME] | 280 (120) |  |  |  |  | 2013-01-31 00:00:00 | All week | All Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014-11-28 00:00:00
[NAME] | 280 (120)
[NAME] | 280 (120) |  |  |  |  | 2013-01-31 00:00:00 | All week | All Week
[NAME] | 280 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VACATION | VACATION |  |  |  |  |  |  |  |  |  |  |  |  |  | VACATION |  |  |  |  |  |  |  |  | VACATION
Security and Controls
[NAME] | 280 (120) |  |  | (PENN TEST) |  | PCI On-Site Audit  1/28/- 1/29 |  |  | 2/17 - 2/21 | 2/24 - 2/25 |  |  | [NAME] |  |  |  | 4/16 - 4/18 | 4/21 - 4/25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12/15 - 12/19
Trish Crisinati | 280 (120) |  |  |  |  |  |  | 2013-02-14 00:00:00 | 2/17 - 2/18
[NAME] | Check
Networking
[NAME] | 160
[NAME] | 280 (120) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4/21 Easter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-08 00:00:00 |  | 2013-08-22 00:00:00 | 2013-08-29 00:00:00 | 9/4 & 9/5 |  |  | 9/22 - 9/26 |  |  |  |  |  |  |  |  | 2013-11-26 00:00:00 |  |  |  | 2013-12-26 00:00:00 | 12/29 - 12/31
Dean Gousse | 280 (120) |  |  |  | 2014-01-20 00:00:00 |  |  |  | 2/17 & 2/18 |  |  |  |  |  |  | 2013-04-11 00:00:00 | 4/14 - 4/18 |  |  |  |  |  | 5/26 H |  |  | 2014-06-20 00:00:00
[NAME] | 240 (120)
[NAME] | 240 (120)
[NAME] | 280 (120) |  |  |  |  |  |  |  | 2013-02-16 00:00:00 |  |  |  |  |  |  |  |  | 4/21- 4/25 |  |  |  |  |  |  |  |  | 2013-06-22 00:00:00 |  |  | 7/13 - 7/17 |  |  | 8/3 - 8/7 | 8/10- 8/14 |  |  | 2013-08-31 00:00:00 |  |  |  |  | 2013-10-08 00:00:00 | 10/12 & 10/13 |  |  |  |  |  |  | 2013-11-30 00:00:00
[NAME] | 240 (120) |  |  |  |  |  |  |  |  | 2/23 - 3/1
[NAME] | 240 (120)
[NAME] | 280 (120) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/28 - 8/1
Hardware Support
[NAME] | 240 (120) |  | 1/9 & 1/10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4/30 - 5/2 | 5/5 - 5/8
[NAME] | 280 (120)
[NAME] | 240 (120)
[NAME] | 280 (120)
[NAME] | 200 (120) |  |  |  | 1/20 & 1/21 |  |  |  |  |  |  |  |  |  |  | 2013-04-07 00:00:00 |  |  |  |  |  |  | 5/26- 5/30 | 2013-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12/22, 12/23, 12/24 & 12/26 | 12/29 - 1/1
[NAME] | 280 (120)
[NAME] | 320 (120) |  |  |  | 2014-01-24 00:00:00
Data Services
[NAME] | 240 (120)
[NAME] | 320 | 12/30 , 12/31, 1/3 |  |  |  |  |  |  |  |  | 3/3 & 3/4
[NAME] | 240 (120) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/5 - 5/8 |  | 2013-05-23 00:00:00 |  | 6/6 - 6/7 |  |  |  | 7/3 - 7/4 | 7/7-7/11 |  |  |  |  |  | 21 - 22 | 25 - 29 |  |  |  |  |  |  | 13 - 17 |  |  |  |  |  | 2013-11-28 00:00:00 |  |  |  | 2013-12-26 00:00:00
[NAME] | 160 (80) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6/20 | 6/23-6/27
Production Support
Debbie Dibble | 320 (120)
[NAME] | 240 (120)
[NAME] | 320 (120)
[NAME] | 320
[NAME] | 1900-11-15 00:00:00
[NAME] | 320
[NAME] | 320
[NAME] | 280
[NAME] | 280
Software Developers
[NAME] | 120
[NAME] | 240
[NAME] | 200
[NAME] | 200
Call Center/Operations
employee a | 320
employee b | 280
employee c | 320
employee d | 280
employee e | 120
employee f | 120
employee g | 120
employee h | 160
employee i | 54
employee j | 1900-08-27 00:00:00
employee k | 1900-06-08 00:00:00
employee l | 1900-06-08 00:00:00
employee m | 132
employee n | 1900-06-08 00:00:00
employee o | 1900-04-10 00:00:00
employee p | 320