Free 3-week look-ahead schedule template: A three-week look-ahead that draws its own bars.
A free Excel workbook for the weekly coordination meeting. Type each task’s start date and working days, and it works out the finish dates, draws the bars across fifteen weekdays and marks the holidays. There is no form to fill out.

What is inside
Six things the workbook does for you.
Fifteen weekday columns
Enter the Monday your look-ahead starts and the three weeks date themselves, Monday to Friday.
Bars that draw themselves
Type a start date and a number of working days. The finish date is calculated and the bar appears, skipping weekends and the holidays you list.
Critical work in a second color
Mark a task with a Y and its bar changes color, so the work that cannot slip stands out in the meeting.
A constraint log on every row
What the task needs first, who is clearing it and the date it is needed by, right beside the task it holds up.
A column for the CPM activity ID
Tie each task to the activity it belongs to, so weekly progress can be carried into the monthly schedule update.
Laid out to print
Set up for one 11 × 17 sheet, landscape. A second sheet explains each column and holds the holiday list.
How to use it
From a blank sheet to the weekly meeting, in eight steps.
Set the week
Type the Monday your look-ahead starts. The fifteen weekday columns fill in by themselves.
List the work
One task per row, by area and trade: “Level 3 east: hang drywall,” not “Level 3 finishes.” Type over the example rows or clear them.
Tie it to the CPM
Put the CPM activity ID beside each task, so weekly progress can be carried into the monthly schedule update.
Start and work days
Type the start date and the number of working days. Finish is calculated, and the bar draws itself across the grid.
Flag critical work
Type Y in the Critical? column for work on the critical path. Those bars turn red.
Screen constraints
For each task, write what must be in place first (an RFI answer, a delivery, an inspection), who is clearing it, and the date it is needed by.
Set the status
Constrained while something under Needs first is still open. Ready when nothing is in the way. Then In progress, and Done.
Run the meeting
Issue it before the weekly coordination meeting. Review last week first, then walk the next three weeks and have each trade confirm its dates.
Column by column
What each column is for.
You type in the cream cells. The gray cells and the day grid, marked “Calculated” below, are worked out for you.
| Column | What goes in it |
|---|---|
| # Calculated | The row number. |
| CPM activity ID | The activity in your CPM schedule that this task belongs to. |
| Task and location | The work, by area and trade. |
| Trade / responsible | The crew or person doing it. |
| Critical? (Y) | A Y if the task is on the critical path. |
| Start | The date the work begins. |
| Work days | How many working days it takes. |
| Finish Calculated | The last working day, skipping weekends and the holidays you have listed. |
| Week 1 to week 3 Calculated | A bar on each working day of the task. Holidays are marked HOL and shaded. |
| Needs first (constraint) | What must be in place before the task can start: an RFI answer, a delivery, an inspection. |
| Who clears it | The person responsible for clearing that constraint. |
| Need by | The date it has to be cleared. |
| Status | Ready, Constrained, In progress or Done, picked from a list. |
Free download
Three-week look-ahead template
Free to use and to adapt on your own projects.
Beyond the template
When a spreadsheet stops being enough.
A template gives you the format. It cannot tell you whether the dates in it still agree with the contract schedule. On a busy job the two drift apart: the field works to the spreadsheet, the owner is shown the CPM schedule, and the monthly update stops describing the real project.
That is the part we do. We keep the look-ahead current each week from a short call with your superintendent, tie every task to its CPM activity, and carry the actual dates into the monthly update.
Common questions
Questions, answered.
Is the look-ahead template really free?
Yes. There is no form, no email address and no trial period. Download it, use it on your own projects and change it to suit them.
Does the template use macros?
No. It is a plain .xlsx workbook built with standard functions such as WORKDAY and COUNTIF, with conditional formatting drawing the bars. There are no macros to enable. Excel may ask you to click Enable Editing first, as it does with any downloaded file.
Will it work in Google Sheets?
It is built for Excel. We have not tested it in Google Sheets or Numbers, so we can’t promise the bars and the drop-down lists behave the same way there.
How do I add holidays?
List them on the “How to use” sheet. Each date you enter is marked HOL on the grid, shaded, and skipped when the finish dates are calculated. Weekends are always skipped.
Can it show more than three weeks?
The grid is fixed at fifteen working days. For a longer make-ready view, keep a second copy of the sheet that starts three weeks later.
Is a look-ahead the same as a CPM schedule?
No. The CPM schedule covers the whole project and calculates the critical path. The look-ahead is the next three weeks of it, broken into daily tasks for the crews. The template has a column for the CPM activity ID so the two stay tied together.
Keep reading
Guides that go with it
How to build a 3-week look-ahead
How to build a three-week look-ahead schedule from your CPM schedule and run the weekly meeting from it. Includes a free Excel look-ahead template.
How to read a schedule update
A guide for owners and project managers: eight questions that show whether a monthly schedule update is telling the truth about progress and the finish.
What is a CPM schedule?
A plain-English guide to CPM scheduling in construction: activities, logic, the forward and backward pass, float and the critical path, with an example.
How we can help
Related services
Look-ahead schedules
Three- and six-week look-aheads tied to the CPM schedule and written for the superintendent and the trades.
Schedule updates & reporting
Your schedule statused against real progress every period, with a plain-English report on what changed and what it affects.
CPM baseline schedules
A complete, logic-driven plan of record, built with your team and checked against the specification before it is submitted.