How to filter a SharePoint Task list to only show items due within 7 days

In this example we are going to show how to create a view that only shows the tasks that are due in the next 7 days.

Step 1 : Create a Tasks List

create-sharepoint-tasks-list

Step 2 : Add a new calculated column called “Expiry” (you can call it what you want). Set the formula to this ‘[Due Date]+7’

create-expiry-column

Please note the example shows ’14’ so just change that how many days you need.

Step 3 : Create a new view called ‘Due in 7 days’.

Now navigate to your list an click ‘Create View’ on the ribbon. Once in the view add a new filter expression as follows :

filter

In our example, we are showing all the tasks where the Expiry Date are due within a week.

You can also use this view when you embed the Tasks list as a web part.

This post by (Ryan at Pentalogic) shows the same solution, but different problem.