How to Complete a Microsoft Project Task Without Changing Actual Dates
Question details
The user needs to complete a Fixed Work task in Microsoft Project after recording fewer actual hours, while preserving the original work dates and project history.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A Fixed Work task was planned with certain dates and hours, but actual work was performed on different dates. The user wants to mark the task complete without Project changing the finish date or actual work incorrectly.
- Observed behavior
- Marking the task complete or entering actual work moves the finish date earlier or recalculates actual work, losing the intended date of the final work.
Before you record progress, set a baseline in Microsoft Project so the original Start, Finish, Duration, and Work values are preserved. Also confirm the task type is Fixed Work and check the resource calendar, because both affect how Project recalculates the finish date.
Record Actual Work in the Task Usage View and Set Remaining Work to Zero
Use this solution when a Fixed Work task is already complete but Project recalculates the finish date because actual hours were entered without the correct work date.
Microsoft Project calculates the finish date from recorded actual work, remaining work, calendars, and assignment details. If you enter hours only in the Actual Work field, Project may spread the hours from the task start and move the intended completion date. Entering the hours in the Task Usage timescale for the real date prevents this.
In Microsoft Project, go to the View tab and click Task Usage to display the timescaled work grid for each task and assignment.
In the Task Usage timescaled cell under the date when the work was performed, type the actual hours such as 8h or 1h. Avoid using only the Actual Work field because it may not record the intended work date.
Select the task, display the Remaining Work field, and set it to 0. Project then calculates Percent Work Complete, Work, and the finish date from the recorded work, calendars, and assignment details.
Review the scheduled Finish, Work, and Percent Work Complete fields. Compare them with Baseline Finish and Baseline Work to confirm the original plan is still available for variance analysis.
Set a Baseline Before Entering Task Progress
Use this solution before execution begins so the original task dates, duration, and work are retained even when scheduled fields change during progress updates.
Use WPS Office as a Free, Lightweight Project Task Tracker
WPS Office does not repair Microsoft Project files, but WPS Spreadsheet gives you a free, lightweight way to record task dates, actual hours, remaining work, and baseline differences in Excel-compatible workbooks. Its familiar ribbon UI makes moving from Microsoft Office simple.
- 1. Download WPS Office: Go to the official WPS Office website and click Download WPS Office Free to install the suite on Windows, macOS, or mobile.
- 2. Open or create a project workbook: Launch WPS Spreadsheet, then open an existing .xlsx task register or create a new workbook with columns for Task, Baseline Start, Actual Start, Baseline Finish, Actual Finish, Work, Actual Work, and Remaining Work.
- 3. Track progress and compare variances: Enter actual dates and hours in the corresponding rows, set Remaining Work to zero for completed tasks, and use formulas or charts to compare baseline versus actual values.
- 4. Save in Excel-compatible format: Save the workbook as .xlsx so it remains compatible with Microsoft Excel and can be shared with team members who use Microsoft Office.

Frequently Asked Questions
Why does my Fixed Work task finish date move when I mark it complete?
Because Microsoft Project recalculates the schedule from actual work and the resource calendar. If actual work is entered in the Actual Work field without a specific date, Project may distribute it from the task start. Enter hours in the Task Usage timescaled cell for the real work date, then set Remaining Work to zero.
How do I enter actual work for a specific date in Microsoft Project?
Open the Task Usage view, locate the timescaled cell under the date when the work was performed, and enter the hours there instead of only using the Actual Work field.
Will setting Remaining Work to zero erase my original plan?
No. It updates the scheduled work and finish fields. Set a baseline before entering progress so Baseline Start, Baseline Finish, Baseline Work, and Baseline Duration keep the original plan for comparison.
Can WPS Office open Microsoft Project files?
WPS Office does not edit .mpp files. However, you can use WPS Spreadsheet to track project tasks, actual hours, and baseline differences in .xlsx format and share the workbook with Microsoft Excel users.




