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
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.