Calculate Microsoft Project Status from Baseline and Forecast Dates
Question details
Calculate task status in Microsoft Project by comparing forecast dates with saved baseline 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.
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.
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.
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.
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.
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].
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.
Insert the renamed custom field as a column in the task view and review its indicators alongside Finish and Baseline Finish.

Check how the built-in Status field uses the status date
Use this check when you need to understand why Project labels a task On Schedule or Late.
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.

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.




