You can add these dates manually if you prefer, or even leave out dates for tasks with subtasks.

This is therefore the start date of the task, likewise I used the =MAX( ) formula to find the maximum date between cells D26 and D33 for the task end date. In the screenshot below I have used the =MIN( ) formula to find the minimum date between cells C26 and C33.

For tasks with subtasks you may prefer to create formulas to calculate the correct dates based on the subtasks.

Delayed – for tasks which are not on track to complete on the baseline end date or before.

On hold – for tasks which you have decided to postpone until a later time.

On track – for tasks that you have started and are still on track to complete by the baseline end date.

Not started – for any tasks which you have not yet started work on.Finally set the status of each task or subtask.You may not have comments on day 1, but as you progress the project this will be useful to add additional information for each task or subtask. If there are multiple people responsible for this task then create individual line items for each responsible person. You should put just one name in each row. In column G add who is responsible for each task.Whenever you baseline the dates of your plan, make sure you reference this date for clarity in cell C3. As you review and revise the plan on a daily basis the dates in columns E and F may change, but the baseline dates should remain static unless you have agreed to re-baseline the plan with project sponsors. If you are creating your plan for the first time then you can put the same dates into columns E and F respectively. These are the dates that your initial plan stated you would complete each task. Now you need some baseline dates into columns C and D.You should format the tasks by making them bold and the sub tasks by indenting them. Add your tasks and sub tasks in column B.In this case you should still update the date to show that the plan was valid on this date. Ideally project plans should be updated daily even if it is to confirm everything is still valid. It’s always useful to date a project plan so people know whether any recent events have been accounted for in the plan yet or not. Add the date on which this plan is valid into cell B3.Download it using the button at the top of the page, then save it locally on your computer.

Gantt chart maker excel free