Others

Calculate Microsoft Project Status from Baseline and Forecast Dates

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

Question details

Calculate task status in Microsoft Project by comparing forecast dates with saved baseline dates.

Calculate Microsoft Project Status from Baseline and Forecast Dates
Product
Microsoft Project
Device & OS
not provided
Scenario
The user wants to identify tasks whose forecast finish dates have slipped from the original baseline.
Observed behavior
The built-in Status field can show a task as on schedule after its forecast finish changes because it evaluates progress against the status date and current task timing.
Before you start

Check that the project has a baseline saved and that the current Finish dates represent the forecasts you want to compare. Set the project status date and, if needed, choose a date format that displays times.

Solution 1Recommended

Create a baseline finish variance stoplight field

Use this approach to flag forecast finishes that are later than the saved baseline, regardless of the built-in Status result.

Finish Variance compares the current Finish with Baseline Finish. A positive variance indicates a later forecast finish; a zero or negative variance indicates a finish on or before the baseline.

This indicator measures baseline finish variance, not progress against the status date. A completed task can still show a positive variance if it finished later than planned.

1
Save or verify the baseline

In Microsoft Project, select Project > Set Baseline > Set Baseline. If a baseline is already saved, verify the Baseline Finish values before changing it; saving a new baseline can replace the original comparison.

2
Check the forecast dates

In a task view, add the Finish and Baseline Finish columns and check that Finish contains the current scheduled or forecast finish for each task.

3
Create a custom field

Select Project > Custom Fields, choose Task and the Duration field type, and select an unused field such as Duration1. Rename it Baseline Finish Status, select Formula, and enter [Finish Variance].

4
Set graphical indicators

In the Custom Fields dialog, select Graphical Indicators. Add a rule for values greater than 0 days with a red indicator and a rule for values less than or equal to 0 days with a green indicator. Add further thresholds if your team uses different severity levels.

5
Display the result

Insert the renamed custom field as a column in the task view and review its indicators alongside Finish and Baseline Finish.

Create a baseline finish variance stoplight field
Duration variance is a different measure: Duration Variance compares task duration with baseline duration. Use Finish Variance when the specific concern is a later finish date.
Free Microsoft Office alternative

Track Baseline and Forecast Dates in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface. Use WPS Spreadsheets to compare baseline and forecast dates in a spreadsheet, and move existing Excel workbooks into your workflow. It does not change Microsoft Project's Status calculation.

Compare baseline and forecast dates in a spreadsheetCompatible with Microsoft Excel formats such as XLSXFamiliar spreadsheet interface for an easier transitionFree and lightweight for everyday Office work
microsoft office alternative - wps office

Frequently Asked Questions

Why can a delayed task show as On Schedule in Microsoft Project?

The built-in Status field evaluates task timing and time-phased progress against the status date, rather than directly comparing Finish with Baseline Finish. A revised forecast can therefore be on schedule even if it is later than the baseline.

Which field shows whether a forecast finish has slipped?

Add the Finish Variance column to a task view. A positive value means the current Finish is later than Baseline Finish, provided a baseline has been saved.

What happens if I do not set a status date?

Microsoft Project uses the current date. To specify the reporting date, select Project > Status Date.

Can I use Duration Variance instead of Finish Variance?

Yes, if you want to flag changes in task duration. For a comparison of finish dates specifically, use Finish Variance because a task's finish can slip without its duration increasing.