Others

How to Create a Microsoft Project Report for Tasks Starting Next Week

Rana GarciaRana Garcia Nov 2, 2026 869 views

Question details

The user needs to generate a task list or report in Microsoft Project specifically for tasks starting next week, based solely on start dates and ignoring finish dates or durations.

How to Create a Microsoft Project Report for Tasks Starting Next Week
Product
Microsoft Project
Device & OS
not provided
Scenario
Generating an accurate upcoming tasks report for project schedule planning without using complex VBA macros.
Observed behavior
Built-in reports like 'Upcoming Tasks' show unexpected or mismatched results because the report's graph and task table are using different filters.
Before you start

Identify the exact calendar dates for the upcoming work week to ensure your custom filter captures the correct working days accurately.

Solution 1Recommended

Create and Apply a Custom Task Filter

Build a custom interactive filter to isolate tasks that start within a specific date range, providing a clean list without needing VBA macros.

Microsoft Project allows you to create highly specific filters. By setting up a custom date range filter based exclusively on the 'Start' field, you can easily generate a list of upcoming tasks regardless of when they finish.

1
Open Filter Settings

Navigate to the 'View' tab on the ribbon, locate the Data group, and click on the 'Filter' dropdown menu.

2
Define New Filter

Select 'New Filter' to open the Filter Definition dialog box. Give your filter a recognizable name, such as 'Tasks Starting Next Week'.

3
Set Start Date Criteria

In the Field Name column, select 'Start'. Under the Test column, choose 'equals or is greater than', and type the first date of next week in the Value column.

4
Set End Date Criteria

Add a second row starting with 'And'. Set Field Name to 'Start', Test to 'equals or is less than', and type the last working date of next week in the Value column.

5
Apply and View

Click 'Save' and apply the filter to your Task Sheet or Gantt Chart view. You can now easily print or export this accurate task list.

Create and Apply a Custom Task Filter
Filter Successfully Applied: Your task view will now exclusively display tasks that initiate during the defined week, ignoring their expected completion dates.
Free Microsoft Office alternative

Track Project Tasks Easily with WPS Office

If you find Microsoft Project too complex for simple task tracking, WPS Spreadsheet provides a free, lightweight, and easy-to-use alternative. It offers full format compatibility with Microsoft Excel and includes a rich library of Gantt chart templates to help you manage schedules seamlessly.

  1. 1. Download and Install: Download WPS Office for free and open the WPS Spreadsheet application.
  2. 2. Find a Template: Click on 'Templates' and search for 'Gantt Chart' or 'Project Management' to find a pre-formatted tracking sheet.
  3. 3. Filter Tasks: Input your task data and use the intuitive Data > Filter tool to display only the tasks scheduled to start next week.
Completely free and lightweight task management alternative100% format compatibility with Microsoft Excel (.xlsx) filesHundreds of built-in Gantt chart and project tracking templatesFamiliar user interface for seamless and quick migration
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Microsoft Project graph show different tasks than my table?

In Microsoft Project, reports are composed of independent elements. A graph and a table in the same report can have different default filters applied to them. You must open the Field List pane for both elements and apply the same custom filter to synchronize the data.

Do I need a VBA macro to list tasks starting next week?

No, a VBA macro is not strictly necessary. While a macro can be written to iterate through start dates, creating a custom 'Start Date' filter with specific 'greater than' and 'less than' parameters is much faster and requires no programming knowledge.

How can I share this filtered task list with team members who don't have Microsoft Project?

Once you have applied your custom date filter to the Task Sheet or Gantt Chart view, you can highlight the visible rows, copy them, and paste them directly into a spreadsheet application like WPS Spreadsheet or Microsoft Excel to easily share with your team.