Others

How to Create a Two-Week Look-Ahead Filter in Microsoft Project

Huma Ashraf ChHuma Ashraf Ch Oct 21, 2026 872 views

Question details

The user needs to filter a Microsoft Project master schedule and its inserted subprojects to exclusively show incomplete tasks starting within the next 14 days.

How to Create a Two-Week Look-Ahead Filter in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
Managing a complex project schedule and needing a short-term tracking view to identify upcoming tasks across multiple project levels.
Observed behavior
Requires a custom filter or field configuration because default filters do not automatically sync with a dynamic 14-day look-ahead across both master and subproject levels.
Before you start

Ensure that your Project Status Date is correctly set and updated, as the look-ahead formula relies on this date to accurately calculate the upcoming two-week window.

Solution 1Recommended

Use a Custom Flag Field and Formula

Create a custom Flag field with a formula that automatically evaluates whether a task falls within the next two weeks based on the project's Status Date.

This method uses an 'IIf' statement to dynamically flag incomplete tasks that start within 14 days of your Status Date. For schedules containing subprojects, the customization must be applied at both the master and subproject levels.

1
Create a Custom Flag

Open your Microsoft Project schedule, right-click on a column header, select 'Custom Fields', and change the field type to 'Flag'. Rename it to something recognizable like '2-Week Look-Ahead'.

2
Enter the Formula

Click the 'Formula' button and enter: Flag1 = IIf([Start] < ([Status Date] + 14) And [% Complete] < 100, "Yes", "No"). Click OK to save.

3
Apply to Subprojects

If your master schedule contains inserted subprojects, open each subproject individually and repeat the custom Flag1 configuration so the formula evaluates properly at all levels.

4
Set Status Date and Filter

Navigate to the 'Project' tab and click 'Project Information' to set your current Status Date. Finally, apply a filter to your task list to only display rows where your custom Flag field equals 'Yes'.

Use a Custom Flag Field and Formula
Recalculate Schedule: After setting the status date and formula, press F9 to recalculate the schedule and ensure all flags update accordingly.
Free Microsoft Office alternative

Track Projects Easily with WPS Spreadsheet

While Microsoft Project provides advanced scheduling for specialized managers, many project tracking scenarios and look-ahead filters can be achieved much easier using WPS Spreadsheet. WPS Office is a free, lightweight suite that supports standard formulas and conditional formatting, perfect for creating highly customizable task trackers without the steep learning curve.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless file sharing.Create custom project tracking templates, Gantt charts, and task lists for free.Use simple spreadsheet formulas to build automated look-ahead filters.Lightweight and smooth performance across Windows, Mac, and Linux environments.
QA img-9

Frequently Asked Questions

Why does my custom flag column only show 'No' for all tasks?

This usually occurs if the Project Status Date has not been set. Navigate to Project > Project Information and update the Status Date to your current reporting period so the formula has a baseline date to calculate the 14 days.

Does the formula automatically apply to inserted subprojects?

No. If you define the formula only at the master-project level, it will only evaluate tasks belonging directly to the master file. You must open and customize the same field at the subproject level for inserted tasks to be evaluated.

Can I simply modify the built-in date range filter?

Yes, you can copy the built-in date-range filter and manually enter the new dates each time you need a report. However, using a custom Flag with a formula automates the process based entirely on your Status Date.