How to Create a Microsoft Project Report for Tasks Starting Next Week
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.

- 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.
Identify the exact calendar dates for the upcoming work week to ensure your custom filter captures the correct working days accurately.
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.
Navigate to the 'View' tab on the ribbon, locate the Data group, and click on the 'Filter' dropdown menu.
Select 'New Filter' to open the Filter Definition dialog box. Give your filter a recognizable name, such as 'Tasks Starting Next Week'.
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.
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.
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.

Adjust Built-in Report Filters
Ensure consistency in built-in reports by aligning the filters used across different visual elements.
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. Download and Install: Download WPS Office for free and open the WPS Spreadsheet application.
- 2. Find a Template: Click on 'Templates' and search for 'Gantt Chart' or 'Project Management' to find a pre-formatted tracking sheet.
- 3. Filter Tasks: Input your task data and use the intuitive Data > Filter tool to display only the tasks scheduled to start next week.

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.




