How to Create a 2-Week Lookahead Filter in Microsoft Project

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:

How to Create a 2-Week Lookahead Filter in Microsoft Project

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

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] and 2 Weeks = ProjDateAdd([Current Date],"10d","Standard")), build a custom filter comparing Scheduled Start against those dates, and copy both into Global.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 Tasks filter 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

  1. Click the Project ribbon tab and click Custom Fields in the Properties section.
  2. In the Custom Fields dialog box, click the Type pick list in the upper-right corner and choose Date.
  3. Create the Today (Date1) field:
    1. Select the Date1 field, click Rename…, type Today, and click OK.
    2. Click Formula…, insert [Current Date], click OK, and select Use formula under Calculation for task and group summary rows.
  4. Create the 2 Weeks Field (Date2):
    1. Select the Date2 field, click Rename…, type 2 Weeks, and click OK.
    2. Click Formula… and paste: text ProjDateAdd([Current Date],"10d","Standard")
    3. (Note: "10d" adds 10 working days, two standard workweeks, using the "Standard" calendar.)
  5. 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

  1. Click View → Filter → New Filter….
  2. Name the filter 2-Week Lookahead and enter these two criteria rows:
And/OrField NameTestValue(s)
Scheduled Startis greater thanToday (Date1)
AndScheduled Startis less than or equal to2 Weeks (Date2)
  1. Check Show related summary rows at the bottom and click Save.
  2. Copy Today (Date1), 2 Weeks (Date2), and your 2-Week Lookahead filter into Global.mpt using 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:

  1. 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.
  2. 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.
  3. 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

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha