How to Create a Two-Week Look-Ahead Filter in Microsoft Project
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.

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

Calculate a Target Date with a Custom Date Field
Alternatively, create a custom Date field to calculate the exact cut-off date, then use a standard date filter to view tasks.
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.

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.




