Calculate Actual Project Progress Percentage in Microsoft Project
Question details
Calculate a meaningful actual project progress percentage when a schedule contains tasks and durations but little or no recorded progress data.

- 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.
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.
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.
In Microsoft Project, open the Project tab, select Status Date, and enter the date through which you want to report progress.
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.
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.
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.

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.

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.




