In this blog post, I’m going to show you how to use the Status Date, a solid red Status Date gridline, and the built-in Late Tasks filter to update project progress like a pro in Microsoft Project. If you have been scrolling up and down a huge project schedule every Friday afternoon trying to figure out which tasks need a status update, this workflow will save you hours every month.
Companion Articles in This Baselines, Variance & Progress Tracking Series: Explore these connected tutorials in the same topic area to build your skills step by step:
- Current Article (You Are Here): How to Use the Status Date and Late Tasks Filter to Update Progress in Microsoft Project
- Companion Tutorial: Why Should You Save a Baseline in Microsoft Project?
- Companion Tutorial: How to Enter Task Progress in Microsoft Project (Step-by-Step)
- Companion Tutorial: Understanding Finish Variance and Other Variance Fields in Microsoft Project
- Full Topic Hub: Browse All Baselines, Variance & Progress Tutorials →
At a Glance: Updating Progress with the Status Date & Late Tasks Filter:
- Applies to: Microsoft Project Standard and Professional (2016, 2019, 2021, 2024, and Project Online Desktop Client).
- Step 1: Set the Status Date (Project -> Status Date) to the end of your current reporting period (for example, last Friday at 5:00 PM).
- Step 2: Right-click the Gantt Chart background, click Gridlines, and format the Status Date line as a solid red vertical gridline so you can see your reporting cutoff in the Gantt Chart screen.
- Step 3: Apply the built-in Late Tasks filter (View -> Filter -> Late Tasks) to isolate every task whose progress is behind the Status Date.
- Step 4: Enter actual progress for those tasks, then use Project -> Update Project to reschedule uncompleted work to start after the Status Date.
Need hands-on help with your schedule? Explore my $399 Microsoft Project Desktop Course, Project Server Training, or book 1-on-1 Private Training & Consulting.
Step 1: Why Must You Set the Status Date Before Entering Progress?
Many project managers ignore the Status Date setting on the Project ribbon tab, leaving it set to NA. When the Status Date is set to NA, Microsoft Project uses your computer’s current date (Current Date) as the cutoff for status calculations.
Wait a minute! What if it is Monday morning and you are entering progress through the end of last Friday’s reporting period? You must explicitly tell Microsoft Project your reporting cutoff date. Here’s how:
- Click the Project ribbon tab.
- In the Status section, click the Status Date button.
- In the Status Date dialog:
- Select the last day of last week’s reporting period (for example, last Friday’s date).
- Click OK.
Step 2: How Do I Display a Solid Red Status Date Gridline on the Gantt Chart?
Even after you set the Status Date in the Status Date dialog, Microsoft Project does not draw a line for it in the Gantt Chart screen by default! Let’s turn on a high-visibility red vertical Status Date line:
- Move your mouse cursor into the white background area of the Gantt Chart screen (where the Gantt bars are displayed), right-click anywhere in the blank space, and click the Gridlines item on the shortcut menu.
- In the Gridlines dialog:
- In the Line to change list on the left, scroll down and select Status Date.
- Under the Normal section on the right, click the Type pick list button and choose the dashed line (the last line style at the bottom of the list).
- Click the Color pick list button and choose Red.
- Click OK.
Now you have a bold red vertical line running down your Gantt Chart screen on your exact Status Date! Any task bar sitting to the left of that red line without a black progress bar running all the way through it is missing progress for the current reporting period.
Step 3: How Does the Built-In “Late Tasks” Filter Work with the Status Date)?
Here is one of the best-kept secrets in Microsoft Project: most users assume the built-in Late Tasks filter checks whether a task is slipping past its Baseline Finish date. It does not!
Instead, Microsoft Project’s built-in Late Tasks filter tests whether the built-in Status field equals Late, which means actual progress is behind where it should be as of the Status Date!
To isolate every task that needs an update for your current status cycle:
- Click the View ribbon tab.
- In the Data section, click the Filter pick list button and select Late Tasks.
- Review the filtered list of tasks:
- For tasks that finished on or before the Status Date, enter their
Actual Start,Actual Finish, or100%complete. - For tasks that are currently in progress, update their actual work, actual duration, or their percentage completed as of the Status Date.
- For tasks that finished on or before the Status Date, enter their
Step 4: How Do I Reschedule Uncompleted Work After the Status Date)?
What if a task on your Late Tasks list was supposed to start last week, but the resource had 0 hours of actual progress (or only completed 2 days out of a 5-day task before the Status Date)? You cannot perform remaining work in the past!
To push all uncompleted work forward so it resumes right after your red Status Date line:
- Clear the filter by clicking View -> Filter -> No Filter.
- Click the Project ribbon tab and click the Update Project button in the Status section.
- In the Update Project dialog:
- Select the radio button labeled Reschedule uncompleted work to start after: (notice it automatically defaults to your Status Date!).
- Leave Entire project selected.
- Click OK.
Microsoft Project automatically moves unstarted past tasks so they begin on the next working day after the Status Date, and splits in-progress tasks so their remaining work sits cleanly to the right of your red Status Date gridline!
Frequently Asked Questions
Why did my red Status Date gridline disappear when I opened a different .mpp file?
Gridline settings are saved inside the active View (such as the Gantt Chart view) of each individual .mpp project file. If you want every new project you create to include the red Status Date gridline automatically, configure it once in your enterprise template or copy your customized Gantt Chart view into Global.mpt using File -> Info -> Organizer.
What are the four possible values of the built-in “Status” column in Microsoft Project?
If you insert the Status column into your task table, Microsoft Project displays one of four values based on your Status Date. These values are Complete (the task is 100% done), On Schedule (actual progress meets or exceeds planned progress through the Status Date), Late (cumulative progress is behind the Status Date), or Future Task (the task is scheduled to start after the Status Date).
How is the Late Tasks filter different from the Slipping Tasks filter?
The Late Tasks filter compares cumulative progress against your Status Date, whereas the Slipping Tasks filter compares your current scheduled Finish date against your saved Baseline Finish date! Use Late Tasks to collect weekly status updates, and pair it with a 2-Week Lookahead filter to review upcoming tasks.
What happens if I click “Update Project” without setting a Status Date first?
If you leave the Project Status Date set to NA, the Update Project dialog defaults to today’s date (Current Date). Setting the Status Date explicitly in Project -> Status Date first ensures all calculations align with your official reporting cutoff.
Ready to master Microsoft Project? If you found this article helpful, check out my free tutorials on my YouTube channel, download my Free Microsoft Project Quality Filters, or explore my structured, expert-led training courses and 1-on-1 coaching at dalehowardmvp.com.





Leave a Reply