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

Task lists can end up being so large that you can’t focus on your priorities.

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


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


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 :


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.