Others

Track Actual Task Dates and Duration in Microsoft Project

Steven ParkerSteven Parker Nov 22, 2026 868 views

Question details

The user wants to track tasks in Microsoft Project using their actual dates and duration instead of relying on assumed dates from percentage complete.

Track Actual Task Dates and Duration in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
Updating a project schedule as tasks start, progress, and finish.
Observed behavior
Entering a nonzero percentage complete can make Project assume the task started as scheduled; marking it complete can also produce an assumed finish date.
Before you start

Check the task calendar and planned schedule, then set a baseline if you want to compare actual progress with the original plan. Confirm the actual start date and any progress information available before updating a task.

Solution 1Recommended

Enter Actual Dates and Duration in the Tracking Table

Use factual task data to record progress and let Project calculate completion and update the schedule.

Actual duration is measured using the task's working calendar, so it may differ from elapsed calendar days. Review remaining duration as work progresses, since it affects the forecast finish.

1
Set a baseline

Before tracking, select Project > Set Baseline > Set Baseline, choose whether to save the entire project or selected tasks, and select OK.

2
Open the Tracking table

In a task view such as Gantt Chart, select View > Tables > Tracking. If a needed field is not visible, use Add New Column to add it.

3
Record the actual start

For a task that has started, enter its factual start date in the Actual Start field rather than entering only a percentage complete.

4
Update progress and finish

Enter the Actual Duration and review Remaining Duration for an in-progress task. When it finishes, enter the factual date in Actual Finish; Project updates the task's completion and schedule.

5
Review work and costs

If applicable, review the Actual Work and Actual Cost fields and enter factual values where appropriate. Check resource assignments and calculation settings if Project calculates those values automatically.

Enter Actual Dates and Duration in the Tracking Table
Check scheduling settings: Task calendars, constraints, scheduling mode, and status-date options can affect the resulting schedule. Use status-date options only when their behavior matches your tracking process.
Free Microsoft Office alternative

Track Project Data in a WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Use WPS Spreadsheets to maintain a simple task tracker and migrate existing spreadsheet data; it does not fix Microsoft Project scheduling or replace its scheduling engine.

Record planned and actual task dates in a spreadsheet trackerOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Project show an actual start when I only entered a percentage complete?

Project can assume that a task started on its scheduled start date when you enter a nonzero percentage complete. Open View > Tables > Tracking and enter the factual date in Actual Start.

How do I record the date a task actually finished?

In View > Tables > Tracking, enter the date in the task's Actual Finish field. Project updates the task as complete and adjusts its schedule using the applicable calendar and settings.

How can I compare actual progress with the original plan?

Before tracking, select Project > Set Baseline > Set Baseline and save the baseline. You can then compare baseline fields with current and actual task values.

Why doesn't actual duration match the number of calendar days?

Project calculates duration using working time from the applicable calendar. Check the project's calendar and the task or resource calendars for nonworking days and hours.