In this blog post, I’m going to walk you through two different ways to create a 2-Week Lookahead Filter in Microsoft Project so you can isolate only the tasks scheduled to start in the next two weeks during team standups or client meetings.
Companion Articles in This Views, Tables, Filters & Formatting Series: Explore these connected tutorials in the same topic area to build your skills step by step:
- Current Article (You Are Here): How to Create a 2-Week Lookahead Filter in Microsoft Project
- Companion Tutorial: Remove Resource Names from Gantt Chart in Microsoft Project
- Companion Tutorial: How to Hide Summary Tasks and Outline Numbers in Microsoft Project
- Companion Tutorial: How to Add and Remove Columns in Microsoft Project
- Full Topic Hub: Browse All Views, Tables & Formatting Tutorials →
At a Glance: Two Ways to Build a Lookahead Schedule in Microsoft Project:
- Applies to: Microsoft Project Standard, Project Professional, and Project Server / Project Online Desktop Client.
- Method 1 (Reusable Custom Filter): Create two custom Date fields (
Today=[Current Date]and2 Weeks=ProjDateAdd([Current Date],"10d","Standard")), build a custom filter comparingScheduled Startagainst those dates, and copy both intoGlobal.mpt. - Method 2 (Built-In Status Date Trick): Set your project Status Date 2, 3, or 4 weeks into the future and apply the built-in
Late Tasksfilter for an instant, zero-formula lookahead schedule.
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.
Method 1: How Do I Build a Dynamic 2-Week Lookahead Custom Filter?
(Special thanks to my fellow former Microsoft Project MVP colleague John Jensen, who originally suggested this two-field formula approach!)
Step 1: Create the “Today” and “2 Weeks” Custom Date Fields
- Click the Project ribbon tab and click Custom Fields in the Properties section.
- In the Custom Fields dialog box, click the Type pick list in the upper-right corner and choose Date.
- Create the
Today(Date1) field:- Select the
Date1field, click Rename…, typeToday, and click OK. - Click Formula…, insert
[Current Date], click OK, and select Use formula under Calculation for task and group summary rows.
- Select the
- Create the
2 WeeksField (Date2):- Select the
Date2field, click Rename…, type2 Weeks, and click OK. - Click Formula… and paste:
text ProjDateAdd([Current Date],"10d","Standard") - (Note:
"10d"adds 10 working days, two standard workweeks, using the"Standard"calendar.)
- Select the
- Click OK, select Use formula for task and group summary rows, and click OK to close the Custom Fields dialog.
Step 2: Create the “2-Week Lookahead” Filter Definition
- Click View → Filter → New Filter….
- Name the filter
2-Week Lookaheadand enter these two criteria rows:
| And/Or | Field Name | Test | Value(s) |
|---|---|---|---|
Scheduled Start | is greater than | Today (Date1) | |
And | Scheduled Start | is less than or equal to | 2 Weeks (Date2) |
- Check Show related summary rows at the bottom and click Save.
- Copy
Today (Date1),2 Weeks (Date2), and your2-Week Lookaheadfilter intoGlobal.mptusing File → Info → Organizer so it is available in every project you open!
Method 2: How Can I Create a 2, 3, or 4-Week Lookahead Without Formulas?
What if your client wants a 3-week lookahead today and a 4-week lookahead next month? You can combine Microsoft Project’s Status Date Gridline with the built-in Late Tasks filter:
- Format the Status Date Gridline: Click Gantt Chart Format → Gridlines → Gridlines…, select Status Date at the bottom of the list, set Type to dashed-dot (
-..-..-) and Color to Red, and click OK. - Set the Status Date into the Future: Click Project → Status Date, select the date 2 weeks from today (or 3 or 4 weeks!), and click OK.
- Apply the Built-In Late Tasks Filter: Click View → Filter → Late Tasks.
Because the built-in Late Tasks filter displays incomplete tasks scheduled prior to the Status Date, moving the Status Date two or three weeks into the future turns Late Tasks into an instant, flexible Lookahead Filter! Just remember to reset your Status Date back to your actual reporting date before entering progress.
Frequently Asked Questions
Why does the ProjDateAdd formula use "10d" instead of "14d"?
In Microsoft Project formulas, "10d" represents 10 working days on the Standard 5-day workweek calendar (Monday–Friday), which equals exactly two calendar weeks (14 elapsed days).
How do I clear a lookahead filter when I’m done reviewing?
Press the F3 function key on your keyboard (or read my guide on How to Identify and Remove Microsoft Project Filters).
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