Others

Calculate Actual Project Progress Percentage in Microsoft Project

Steve KSteve K Nov 22, 2026 868 views

Question details

Calculate a meaningful actual project progress percentage when a schedule contains tasks and durations but little or no recorded progress data.

Calculate Actual Project Progress Percentage in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
A project manager wants to report actual progress as of a status date and compare it with the planned schedule.
Observed behavior
Planned percentages can exceed 100% or miss early completions, while actual progress cannot be established without recorded progress facts.
Before you start

Choose a status date and decide whether progress should measure duration, work, or cost. Check which actual and remaining values are available for the tasks before interpreting a percentage.

Solution 1Recommended

Record actual task progress and review duration-based completion

Use this method when the plan has task durations but no resource, work, or cost data.

1
Set the status date

In Microsoft Project, open the Project tab, select Status Date, and enter the date through which you want to report progress.

2
Show progress fields

Open View > Gantt Chart. Right-click a column heading and choose Insert Column to add Actual Start, Actual Duration, Remaining Duration, Actual Finish, and % Complete.

3
Enter recorded task facts

For each task, enter the actual start and actual duration observed by the status date, along with a realistic remaining duration. Enter an actual finish date for tasks that have finished, including those completed early.

4
Review project completion

On the Gantt Chart Format tab, select Project Summary Task to display the top-level summary row. Review its % Complete alongside the task-level actual and remaining durations.

Record actual task progress and review duration-based completion
Know what the percentage measures: % Complete is duration-based; it is not a measure of actual work or cost. Without recorded actual progress, a schedule alone cannot establish actual completion. Do not treat planned progress as actual unless the project has progressed exactly as planned.
Free Microsoft Office alternative

Track project progress in a WPS spreadsheet

WPS Office is a free, lightweight alternative for maintaining a project progress table in a familiar spreadsheet interface. Open compatible Excel files and move existing spreadsheet-based reports into WPS, while continuing to use Microsoft Project for its native schedule and calculations.

Record actual and remaining task durations in a progress tableOpen and edit Microsoft Excel XLS and XLSX spreadsheetsUse familiar spreadsheet tools for a smooth transition from ExcelWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Project calculate actual progress from planned dates alone?

No. Planned dates show the schedule, not what actually happened. Enter facts such as Actual Start, Actual Duration, Remaining Duration, and Actual Finish in the Gantt Chart to calculate duration-based actual progress.

How do I account for a task that finished early?

Insert the Actual Finish column in the Gantt Chart and enter the date the task actually finished. Check Actual Duration and % Complete to confirm that the recorded values reflect what happened.

Why can a planned progress percentage exceed 100%?

A custom formula may continue counting elapsed time after the planned finish or use inconsistent dates or durations. Check the formula's date boundaries and handle zero-duration tasks separately. A planned calculation is still not actual progress.

What should I use if I want progress based on work or cost?

Record the relevant resource work or cost data and their actual values as they occur. Then use work- or cost-based fields and reports rather than interpreting duration-based % Complete as work or cost progress.