Others

View Historical Actual Work by Date in Microsoft Project

Kushani NimanthikaKushani Nimanthika Nov 20, 2026 868 views

Question details

View actual work completed on each date and compare cumulative progress over time.

View Historical Actual Work by Date in Microsoft Project
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.
Before you start

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.

Solution 1Recommended

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.

1
Open a usage view

Select View > Task Usage to review work by task, or View > Resource Usage to review it by resource.

2
Add actual work

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.

3
Set daily intervals

Right-click the timescale above the grid, choose Timescale, and set a displayed tier to Days. Scroll to the dates you want to compare.

4
Compare with planned work

If a baseline exists, right-click the time-phased grid and add Baseline Work to compare planned values with Actual Work.

Show daily actual work in a usage view
Cumulative Work is not always cumulative actual work: You can add Cumulative Work to the grid, but it can include scheduled work as well as actual work. Use it as a completed-work total only when you have verified that the included work is actual.
Free Microsoft Office alternative

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.

Calculate cumulative actual work from daily values with spreadsheet formulasCompatible with Microsoft Excel XLSX files for sharing and migrationFamiliar spreadsheet interface for reviewing project dataFree and lightweight office tools
microsoft office alternative - wps office

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.