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

 |  |  |  |  |  |  |  |  |  |  | PM's Colour Codes
 |  |  |  | Programme |  |  |  |  |  |  | # |  | Description |  |  |  |  |  | # |  | Description
 |  |  |  |  |  |  |  |  |  |  | 1 | EDISL |  |  |  |  |  |  | 6 | ADMIN / PM
 | Project Title: |  |  | Project Number: |  |  |  |  |  |  | 2 | LDNSL |  |  |  |  |  |  | 7 | STAT HOLS
 |  |  |  |  |  |  |  |  |  |  | 3 | NCLCL |  |  |  |  |  |  | 8 | DXB SL
 | Prepared by: |  |  | Date updated: |  |  |  |  |  |  | 4 | NCLSL |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 5 | NCLGL |  |  |  |  |  |  | 0
 |  |  |  |  |  | Weeks |  |  |  | 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
 |  |  |  |  |  | Days | Locked Calculated Cells |  |  | 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
 | Ref | Task / Item | Colour Code (1-5) | Task Start Date (DD/MM/YY) | Task  Duration (days) | Dependency Notes | Days (calc) | Week Start (Monday, [NAME]) | End Date (Calc) | 2021-05-31 00:00:00
 | 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
 |  | [NAME] 2 | 1 | 2021-07-26 00:00:00 | 14
 |  | 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 4 | 1 | 2021-10-18 00:00:00 | 7
 |  | NAME 4 | 1
 |  | NAME 4 | 1
 | LDNSL | NAME 1 | 2
 |  | NAME 1 | 2
 |  | [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 3 | 2
 | NCLCL | NAME 1 | 3
 |  | [NAME] 2 | 3
 |  | [NAME] 2 | 3
 | NCLSL | NAME 1 | 4 | 2021-06-28 00:00:00 | 7
 |  | NAME 1 | 4 | 2021-08-09 00:00:00 | 9
 |  | [NAME] 2 | 4 | 2021-08-31 00:00:00 | 4
 |  | [NAME] 2 | 4
 |  | [NAME] 2 | 4 | 2021-07-01 00:00:00 | 9
 |  | 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 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
 | NCLGL | NAME 1 | 5
 |  | NAME 1 | 5 | 2021-07-16 00:00:00 | 1
 |  | [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 | 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 | 5 | 2021-06-28 00:00:00 | 7
 |  | NAME 4 | 5 | 2021-08-16 00:00:00 | 7
 | PM | NAME 1 | 6 | 2021-06-01 00:00:00 | 4
 |  | NAME 1 | 6 | 2021-06-21 00:00:00 | 5
 |  | NAME 1 | 6 | 2021-06-25 00:00:00 | 4
 | STAT HOLS | Spring Bank Holiday (UK) | 7 | 2021-05-31 00:00:00 | 1
 |  | Summer Bank Holiday (Scotland) | 7 | 2021-08-02 00:00:00 | 1
 |  | Summer Bank Holiday (England) | 7 | 2021-08-30 00:00:00 | 1
 |  | [NAME] (Scotland) | 7 | 2021-11-30 00:00:00 | 1
 |  | Christmas Day (Substitute) | 7 | 2021-12-27 00:00:00 | 1
 |  | Boxing Day (Substitute) | 7 | 2021-12-28 00:00:00 | 1
 | DXB HOLS | Eid | 7 | 2021-07-19 00:00:00 | 5
 | DXB SL | NAME 1 | 8 | 2021-06-27 00:00:00 | 7
 |  | NAME 1 | 8 | 2021-07-25 00:00:00 | 2