Project Milestone Planner

Who this is for

A project's milestones on one page, with the slippage counted. Each row is one milestone: who owns it, when it was planned for, when it actually happened, how many days late that was, and where it stands now.

Anyone running a piece of work with dates in it — a launch, a move, a build, a report, an event — at work or outside it, who wants the plan and the reality on the same sheet.

What this helps you track

• Every milestone in order, with a named owner
• The planned date beside the actual date, once there is one
• How many days late each milestone landed, worked out for you
• The status of each — not started, in progress, done or blocked
• How many milestones are done, and the worst slip so far

How to use it

1. Write the project, who is leading it, the start date and the target finish at the top.
2. List the milestones in the order they have to happen, with an owner and a planned date for each.
3. As each one lands, write the actual date. The days-late column compares the two in the browser version and the workbook; a negative figure means it came early.
4. Set the status as things move, and use the notes column for what is holding a milestone up or what it depends on.
5. The summary counts the milestones done and shows the largest slip. Read it at each check-in.
6. When a plan is revised, change the planned date and say why in the notes, so the history is not lost.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

What is a milestone?

A point where something is finished or decided, rather than a task in progress: design signed off, supplier chosen, doors open. If it cannot be dated, it is probably a task, and it belongs in the notes under the milestone it serves.

What does days late show before the milestone has happened?

Nothing — it waits for an actual date. Once one is entered it shows the difference from the planned date, negative if early.

Can I use it for a personal project?

Yes. A house move, a wedding, a course, a garden — anything with a sequence of dates. Put yourself down as the owner and carry on.

Is there a more detailed version?

The project plan sheet on this site breaks the work into tasks with dependencies. This planner is the summary that sits on top of it — a page, not a plan.