View Historical Actual Work by Date in Microsoft Project
Question details
View actual work completed on each date and compare cumulative progress over time.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A user wants a daily, time-phased view of actual work and may also want to compare it with planned work.
- Observed behavior
- Changing the status date does not necessarily show a historical snapshot of actual work.
Open the project and confirm that actual work has been recorded for the tasks or resource assignments you want to review. If you need to compare actual work with the original plan, check that a baseline has been saved.
Show daily actual work in a usage view
Use a time-phased view to see the actual work currently recorded for each day.
The status date is a reference for reporting and updating progress; changing it does not restore an earlier version of the project.
The displayed values reflect the actual work currently stored in the project. If historical entries were changed or removed, the view may not reproduce what an earlier report showed.
Select View > Task Usage to review work by task, or View > Resource Usage to review it by resource.
Right-click the time-phased grid on the right and select Actual Work from the detail fields. Use Detail Styles or Add Details if Actual Work is not listed.
Right-click the timescale above the grid, choose Timescale, and set a displayed tier to Days. Scroll to the dates you want to compare.
If a baseline exists, right-click the time-phased grid and add Baseline Work to compare planned values with Actual Work.

Calculate cumulative actual work in a spreadsheet
Use this method when you need a running total based only on daily actual work.
Calculate Daily Work Totals in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet data. Move daily actual-work values from Microsoft Project into WPS Spreadsheet to calculate running totals; WPS does not change Project's status-date behavior.

Frequently Asked Questions
Why doesn't changing the status date show an old project snapshot?
The status date is a reporting and progress reference, not a command to restore historical project data. Use View > Task Usage or Resource Usage to inspect the actual work currently recorded by date.
How do I see actual work for each day?
Open View > Task Usage or Resource Usage, right-click the time-phased grid, and add Actual Work. Right-click the timescale and set a displayed tier to Days.
Does Cumulative Work show only work already completed?
Not necessarily. Cumulative Work can include scheduled work as well as actual work. For a running total of actual work alone, sum the daily Actual Work values in a spreadsheet.
How can I compare actual work with an eight-hour-per-day plan?
If the plan was saved as a baseline, add Baseline Work and Actual Work to the time-phased grid in a usage view. Set the timescale to Days to compare the values for each date.
Can I recover actual work that was overwritten?
The current usage view shows the values stored in the project, not necessarily prior entries. Check an earlier saved project version or an available historical report for the overwritten values.




