Spreadsheet: 60742d1261286265-vacation-gantt-conditional-formatting-vacation-gantt
Sheet: Vacation Gantt

Start Date: | 2009-12-15 00:00:00
Weeks: | 2009-12-15 00:00:00 | 2010-01-18 00:00:00 |  |  | 0 | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-19 00:00:00 | 2009-12-20 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-25 00:00:00 | 2009-12-26 00:00:00 | 2009-12-27 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00
Name |  |  |  |  |  | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-17 00:00:00 | 2009-12-18 00:00:00 | 2009-12-19 00:00:00 | 2009-12-20 00:00:00 | 2009-12-21 00:00:00 | 2009-12-22 00:00:00 | 2009-12-23 00:00:00 | 2009-12-24 00:00:00 | 2009-12-25 00:00:00 | 2009-12-26 00:00:00 | 2009-12-27 00:00:00 | 2009-12-28 00:00:00 | 2009-12-29 00:00:00 | 2009-12-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 |  |  | Name >> | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Mario
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Return Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days | Vacation Start Date | Vacation End Date | Duration (Days) | Working Days
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 7 | 5 | 2009-12-31 00:00:00 | 2010-01-10 00:00:00 | 10 | 6 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 7 | 5 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 4 | 2 | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 1 | 2 | 2010-01-15 00:00:00 | 2010-01-17 00:00:00 | 2 | 1 | 2009-12-24 00:00:00 | 2009-12-28 00:00:00 | 4 | 2 | 2010-01-02 00:00:00 | 2010-01-05 00:00:00 | 3 | 2 | 2010-01-15 00:00:00 | 2010-01-19 00:00:00 | 4 | 2 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X |  |  |  |  |  | 2010-01-10 00:00:00 | 2010-01-14 00:00:00 | 4 | 4 |  |  | 0 | 0 | 2009-12-21 00:00:00 | 2010-01-03 00:00:00 | 13 | 8 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 | 2009-12-21 00:00:00 | 2010-01-04 00:00:00 | 14 | 9 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
Mario