Free milestone plan template for Excel (baseline vs forecast)
A free milestone plan template for Excel to track your milestones against the agreed dates. Enter the baseline once, update the forecast at each status meeting, and the slip in days is calculated for you.
What's inside
| Column | Use |
|---|---|
| Task ID | Unique code (M1, M2, …); never change it |
| Title | Milestone name |
| Owner | Who is responsible |
| Phase | Intake, Preparation, Execution, Handover, Close |
| Baseline date | The originally agreed date; set once |
| Forecast date | Current best estimate; update regularly |
| Completed date | Date the milestone was reached |
| Status | Not started, In progress, Completed |
| Type | "Milestone" |
| Slip (days) | Calculated: forecast − baseline |
| Notes | Reason for changes |
See it as a timeline
Load the file into the Project Health Check. Because it has a baseline column, one file is enough: you get a milestone timeline with baseline vs forecast, a slip table and next steps for each delayed milestone.
Need tasks as well?
Use the project plan template with phases, tasks and milestones.