BuildQuantify logoBuildQuantify
Excel Tutorials / Gantt-Style Construction Schedule in Excel
SCHEDULING

Gantt-Style Construction Schedule in Excel

9 min read · Template referenced below

You don't need scheduling software to visualize a project timeline — conditional formatting can turn a plain grid of dates into a bar-chart schedule that updates as you change start and end dates.

1
Lay out your task list.
Column A: Task name. Column B: Start Date. Column C: End Date. Then, starting in column D, list every date of your project timeline across the header row (one column per day or week).
2
Select the date grid.
Highlight the block of cells under your date headers, next to each task row — this is where the bars will appear.
3
Add a conditional formatting rule.
Go to Conditional Formatting → New Rule → "Use a formula," and enter: =AND(D$1>=$B2,D$1<=$C2) (adjust cell references to match your layout). This fills a cell orange whenever that date falls between the task's start and end date.
4
Set the fill color.
Choose a solid fill in the formatting options — this becomes your "bar" segment for each task, automatically shifting if you change a start or end date.
Freeze the first three columns (View → Freeze Panes) so task names stay visible while you scroll across a multi-month timeline.

This method has a real advantage over dedicated scheduling software for small jobs: everyone on the team already has Excel, and there's no learning curve to read or update it.

Worked example: a four-task schedule

TaskStartEndDuration
ExcavationOct 5Oct 95 days
FootingsOct 12Oct 165 days
Foundation wallsOct 19Oct 288 working days
BackfillOct 29Oct 302 days

With one column per day and the formula from step 3, each task shows as a solid bar. Change Footings to end on Oct 20 and the bar stretches immediately, without any redrawing.

Make it behave like real scheduling software

  • Link tasks together. Instead of typing a start date, use =WORKDAY(PredecessorEnd,1) so a task begins on the next working day after the previous one finishes. Move the first task and the whole chain shifts.
  • Calculate end dates from durations. Enter a duration in working days and use =WORKDAY(Start,Duration-1) for the end date.
  • Show today. Add a second conditional format rule, =D$1=TODAY(), with a red border or fill to draw a vertical today line.
  • Use weekly columns for long jobs. Put the week-start date in each header and use =AND($B2<=D$1+6,$C2>=D$1) so a task fills any week it overlaps.

Common mistakes

  • Headers typed as text. If the date headers are text, the comparison fails and no bars appear. Make sure they are real dates.
  • Wrong dollar signs. The row-locked D$1 and column-locked $B2 are intentional; if you drop them, the bars shift when the rule is copied.

Frequently asked questions

Can this show dependencies and critical path?

Not automatically. This approach is best for small jobs and simple sequences. For critical-path analysis on larger projects, use dedicated scheduling software.

How do I print it on one page?

Set Page Layout → Orientation to Landscape and Scale to Fit to 1 page wide, then set the print area to the task list plus the date grid.

Back to all tutorials →
← Back to all tutorials