Spreadsheet: 738303d1624962851-gantt-chart-need-to-track-multiple-dates-gantt-example
Sheet: ProjectSchedule

Create a Project Schedule in this worksheet. Enter title of this project in cell B1.  Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions.
Enter Company Name in cell B2. | Company Name
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Pooject Start: label is in cell [NAME]. | Project Lead | Project Start: |  | 2021-06-01 00:00:00
The Display Week in cell E4  represents the starting week to display in the project schedule in cell [NAME]. The project start date is considered Week 1. To change the display week, simply enter a new week number in cell E4. The starting date for each week, starting with the display week from cell [NAME], starts in cell [NAME] and is auto calculated. There are 8 weeks represented in this view from cell I4 through cell BF4. You should not modify these cells. Display Week: label is in cell C4. |  | Display Week: |  | 1
Cells I5 through BL5 contain the day number for the week represented in the cell block above each date cell and are auto calculated. You should not modify these cells. Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule.
This row contains headers for the project schedule that follows below them.  [NAME] from B6 through BL 6 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I6 and continues through cell [NAME]. All project timeline charting is auto generated based on the start and end dates entered, using conditional formats. Do not modify content in cells within columns after column I starting with cell I7. | Teemo order # | Product Name | Factory | PO delivery date | Client shipdate | Original vessel ETD | Revised vessel ETD |  | DAYS
Cell B9 contains the sample task "Task 1."  Enter a new task name in cell B9. Enter a person to assign the task to in cell C9. Enter progres of the task in cell D9. A progress bar appears in the cell and is shaded according to the number in the cell. For example, 50 percent progress would shade half of the cell. Enter task start date in cell E9. Enter task end date in cell F9. A status bar shaded for the dates entered appears in blocks starting from cell I9 through [NAME]. | 8325 | LOGAN WIDE TV UNIT | SVM | 2021-06-13 00:00:00 | 2021-06-20 00:00:00 | 2021-06-22 00:00:00 | 2021-07-01 00:00:00
Rows 10 through 13 repeat the pattern from row 9.  Repeat the instructions from cell A9 for all task rows in this worksheet. Overwrite any sample data. A sample of another phase starts in cell A14.  Continue entering tasks in cells A10 through A13 or go to cell A14 to learn more. | 8325 | [NAME] | SVM | 2021-06-13 00:00:00 | 2021-06-20 00:00:00 | 2021-06-23 00:00:00 | 2021-07-01 00:00:00
 | 8326 | LOGAN WIDE TV UNIT | SVM | 2021-08-08 00:00:00 | 2021-08-15 00:00:00 | 2021-06-20 00:00:00 | 2021-07-01 00:00:00
 | 8326 | [NAME] | SVM | 2021-08-08 00:00:00 | 2021-08-15 00:00:00 | 2021-06-08 00:00:00 | 2021-07-01 00:00:00
 | 8326 | LOGAN 3 DRAWER CHEST | SVM | 2021-08-08 00:00:00 | 2021-08-15 00:00:00 | 2021-06-09 00:00:00 | 2021-07-01 00:00:00
 | 8331 | GRAYSON BOOKCASE OAK | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-09 00:00:00 | 2021-06-12 00:00:00
 | 8331 | GRAYSON BOOKCASE WALNUT | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-23 00:00:00 | 2021-07-01 00:00:00
 | 8332 | GRAYSON DESK OAK | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-20 00:00:00 | 2021-07-01 00:00:00
 | 8332 | GRAYSON DESK WALNUT | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-20 00:00:00 | 2021-07-01 00:00:00
 | 8332 | GRAYSON BOOKCASE OAK | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-20 00:00:00 | 2021-07-01 00:00:00
 | 8333 | HARVARD 2 DOOR CABINET LIGHT GREY | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-09 00:00:00 | 2021-06-25 00:00:00
 | 8333 | HARVARD 2 DOOR CABINET PEACOCK | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-09 00:00:00 | 2021-06-23 00:00:00
 | 8333 | HARVARD MEDIA UNIT LIGHT GREY | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-09 00:00:00 | 2021-06-23 00:00:00
 | 8333 | GRAYSON BOOKCASE WALNUT | BUI | 2021-05-29 00:00:00 | 2021-06-05 00:00:00 | 2021-06-23 00:00:00 | 2021-07-01 00:00:00
 | 8334 | HARVARD 2 DOOR CABINET LIGHT GREY | BUI | 2021-06-05 00:00:00 | 2021-06-12 00:00:00 | 2021-06-23 00:00:00 | 2021-07-01 00:00:00
This is an empty row