Spreadsheet: 739281d1625610831-formulae-and-conditional-formatting-help-gantt-chart-in-excel-annual-leave-calendar-gantt-chart-mflorance1-
Sheet: Sheet1

Ref | Task / Item | Colour Code (1-5) | Task Start Date (DD/MM/YY) | Task  Duration (days) | Task End Date
 | Boxing Day (Substitute) | 7 | 2021-12-28 00:00:00 | 1 |  |  | EDISL | NAME 1 | 1 | 2021-07-05 00:00:00 | 14
 | Christmas Day (Substitute) | 7 | 2021-12-27 00:00:00 | 1 |  |  | EDISL | NAME 1 | 1 | 2021-08-02 00:00:00 | 7
DXB HOLS | Eid | 7 | 2021-07-19 00:00:00 | 5 |  |  | EDISL | NAME 1 | 1 | 2021-10-04 00:00:00 | 7
EDISL | NAME 1 | 1 | 2021-07-05 00:00:00 | 14
 | NAME 1 | 1 | 2021-08-02 00:00:00 | 7
 | NAME 1 | 1 | 2021-10-04 00:00:00 | 7 |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5 |  |  |  |  | 6 |  |  |  |  | 7 |  |  |  |  | 8 |  |  |  |  | 9 |  |  |  |  | 10 |  |  |  |  | 11 |  |  |  |  | 12 |  |  |  |  | 13 |  |  |  |  | 14 |  |  |  |  | 15 |  |  |  |  | 16 |  |  |  |  | 17 |  |  |  |  | 18 |  |  |  |  | 19 |  |  |  |  | 20 |  |  |  |  | 21 |  |  |  |  | 22 |  |  |  |  | 23 |  |  |  |  | 24 |  |  |  |  | 25 |  |  |  |  | 26 |  |  |  |  | 27 |  |  |  |  | 28 |  |  |  |  | 29 |  |  |  |  | 30 |  |  |  |  | 31
LDNSL | NAME 1 | 2 |  |  |  |  |  | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI | MON | TUE | WED | THU | FRI
 | NAME 1 | 2 |  |  |  |  |  | 2021-05-31 00:00:00
NCLCL | NAME 1 | 3 |  |  |  |  |  | NAME 1 | 6 | 2021-06-25 00:00:00 | 4
NCLSL | NAME 1 | 4 | 2021-06-28 00:00:00 | 7
 | NAME 1 | 4 | 2021-08-09 00:00:00 | 9 |  |  |  | 2021-05-31 00:00:00 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-07-02 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-05 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 2021-07-10 00:00:00 | 2021-07-11 00:00:00 | 2021-07-12 00:00:00 | 2021-07-13 00:00:00 | 2021-07-14 00:00:00 | 2021-07-15 00:00:00 | 2021-07-16 00:00:00 | 2021-07-17 00:00:00 | 2021-07-18 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-22 00:00:00 | 2021-07-23 00:00:00 | 2021-07-24 00:00:00 | 2021-07-25 00:00:00 | 2021-07-26 00:00:00 | 2021-07-27 00:00:00 | 2021-07-28 00:00:00 | 2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-01 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-05 00:00:00 | 2021-08-06 00:00:00 | 2021-08-07 00:00:00 | 2021-08-08 00:00:00 | 2021-08-09 00:00:00 | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | 2021-08-13 00:00:00 | 2021-08-14 00:00:00 | 2021-08-15 00:00:00 | 2021-08-16 00:00:00 | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-19 00:00:00 | 2021-08-20 00:00:00 | 2021-08-21 00:00:00 | 2021-08-22 00:00:00 | 2021-08-23 00:00:00 | 2021-08-24 00:00:00 | 2021-08-25 00:00:00 | 2021-08-26 00:00:00 | 2021-08-27 00:00:00 | 2021-08-28 00:00:00 | 2021-08-29 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-11 00:00:00 | 2021-09-12 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-18 00:00:00 | 2021-09-19 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 | 2021-10-01 00:00:00 | 2021-10-02 00:00:00 | 2021-10-03 00:00:00 | 2021-10-04 00:00:00 | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2021-10-07 00:00:00 | 2021-10-08 00:00:00 | 2021-10-09 00:00:00 | 2021-10-10 00:00:00 | 2021-10-11 00:00:00 | 2021-10-12 00:00:00 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 2021-10-16 00:00:00 | 2021-10-17 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 2021-10-22 00:00:00 | 2021-10-23 00:00:00 | 2021-10-24 00:00:00 | 2021-10-25 00:00:00 | 2021-10-26 00:00:00 | 2021-10-27 00:00:00 | 2021-10-28 00:00:00 | 2021-10-29 00:00:00 | 2021-10-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-01 00:00:00
NCLGL | NAME 1 | 5 |  |  |  |  |  | [NAME] 2 | 1 | 2021-07-26 00:00:00 | 14
 | NAME 1 | 5 | 2021-07-16 00:00:00 | 1 |  |  | NAME 1
PM | NAME 1 | 6 | 2021-06-01 00:00:00 | 4 |  |  | [NAME] 2
 | NAME 1 | 6 | 2021-06-21 00:00:00 | 5 |  |  | NAME 3
 | NAME 1 | 6 | 2021-06-25 00:00:00 | 4 |  |  | NAME 4
DXB SL | NAME 1 | 8 | 2021-06-27 00:00:00 | 7
 | NAME 1 | 8 | 2021-07-25 00:00:00 | 2
 | [NAME] 2 | 1 | 2021-07-26 00:00:00 | 14
 | [NAME] 2 | 2 | 2021-08-11 00:00:00 | 1
 | [NAME] 2 | 2 | 2021-09-21 00:00:00 | 4
 | [NAME] 2 | 2 | 2021-06-18 00:00:00 | 4
 | [NAME] 2 | 3 |  |  |  |  |  | NAME 3 | 1 | 2021-06-14 00:00:00 | 7
 | [NAME] 2 | 3 |  |  |  |  |  | NAME 3 | 1 | 2021-09-20 00:00:00 | 7
 | [NAME] 2 | 4 | 2021-08-31 00:00:00 | 4
 | [NAME] 2 | 4 |  |  |  |  |  | NAME 3 | 4 | 2021-07-21 00:00:00 | 1
 | [NAME] 2 | 4 | 2021-07-01 00:00:00 | 9
 | [NAME] 2 | 5 | 2021-08-06 00:00:00 | 8
 | [NAME] 2 | 5 | 2021-08-27 00:00:00 | 1
 | [NAME] 2 | 5 | 2021-09-27 00:00:00 | 7
 | [NAME] 2 | 5 | 2021-06-28 00:00:00 | 7
 | NAME 3 | 1 | 2021-10-18 00:00:00 | 7
 | NAME 3 | 1 | 2021-06-14 00:00:00 | 7
 | NAME 3 | 1 | 2021-09-20 00:00:00 | 7
 | NAME 3 | 1 | 2021-06-28 00:00:00 | 14
 | NAME 3 | 2 |  |  |  |  |  | NAME 4 | 5 | 2021-06-28 00:00:00 | 7
 | NAME 3 | 4 | 2021-07-21 00:00:00 | 1
 | NAME 3 | 4 | 2021-07-23 00:00:00 | 6
 | NAME 3 | 4 | 2021-08-20 00:00:00 | 1
 | NAME 3 | 5 | 2021-08-02 00:00:00 | 14
 | NAME 3 | 5 | 2021-08-23 00:00:00 | 7
 | NAME 3 | 5 | 2021-10-25 00:00:00 | 3
 | NAME 4 | 1 | 2021-10-18 00:00:00 | 7
 | NAME 4 | 1
 | NAME 4 | 1
 | NAME 4 | 4 | 2021-07-26 00:00:00 | 1
 | NAME 4 | 4 | 2021-09-06 00:00:00 | 15
 | NAME 4 | 4 | 2021-07-29 00:00:00 | 2
 | NAME 4 | 5 | 2021-06-28 00:00:00 | 7
 | NAME 4 | 5 | 2021-08-16 00:00:00 | 7
STAT HOLS | Spring Bank Holiday (UK) | 7 | 2021-05-31 00:00:00 | 1
 | [NAME] (Scotland) | 7 | 2021-11-30 00:00:00 | 1
 | Summer Bank Holiday (England) | 7 | 2021-08-30 00:00:00 | 1
 | Summer Bank Holiday (Scotland) | 7 | 2021-08-02 00:00:00 | 1