How to Create a Project Schedule in Excel (with Easy Steps)


Watch Video – Create a Project Schedule in Excel

Step 1: Recording Project Schedule Details to Create a Project Schedule

  • You need to record the project details, i.e., tasks, start date, duration, end date, status, etc., as shown in the picture below.

record project details

Step 2: Creating Scheduled Dates

  • Enter the dates from the first task’s start date to the last task’s end date. Change the text orientation to vertical and adjust the column widths.

enter dates from start to end of the project

Step 3: Entering a Formula to Create a Project Schedule

  • Enter the following formula in cell G5 and copy it to cell AF14.

enter formula for project schedule

Step 4: Applying Conditional Formatting

  • You must apply conditional formatting to get the desired result.
  • Select the range G5:AF14 and go to Home >> Conditional Formatting >> New Rule.

Excel Conditional Formatting to Create Project Schedule

  • Select Format only cells that contain >> Cell Value >> equal to and type Complete in the text box.
  • Click on Format, and pick a Fill color.
  • Click OK.

conditional formatting rule

  • Apply another conditional formatting rule for the In Progress status in the same range. After that, you will see the following result.

creating a Gantt Chart

If you change any status from ‘In Progress’ to ‘Complete’, the schedule chart will change accordingly.

Step 5: Finalizing a Project Schedule

  • Select the range G5:AF14, press CTRL + 1, go to the Custom category, type 3 semicolons (;;;) in the Type field, and click OK.

use 3 semicolons for custom cell formatting

You will get your project schedule as follows.

Finalized Project Schedule

Read More: How to Make a Work Schedule in Excel

Simple Project Schedule/ Gantt Chart Templates in Excel 2021


  • Search for online templates before creating a new workbook using the keyword “Gantt Chart”.
  • Choose the suitable one and click on it.

choose from Excel templates for project schedule

  • Create a new workbook from this template.

create new project timeline from excel templates

  • You can modify the template as needed.

use or modify the project planner template

Read More: How to Create a Workback Schedule in Excel

Things to Remember

  • Apply the mixed cell references in the formulas carefully. Otherwise, copying them using the Fill Handle will give you erroneous results.
  • Don’t forget to select the range before applying conditional formatting.

Download Free Project Schedule Template in Excel

The download button below lets you download the project schedule template for free.

Related Articles

<< Go Back to Excel for Business | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF