I am trying to create a view where Invoice Admin wants to see all the records where invoice due dates are within next 5 days. I added a calculated column and i have =[DueDate]-5 but this formula only gives me the records that have a DueDate 5 days from now. Is there a way to get all the records that are due from today to 5 days from today?

2 Answers 2


You don't need a calculated column for this. Just use your existing [DueDate] column twice in your view filter:

Show the items when column
is greater than or equal to


when column
is less than or equal to

  • The list is huge. Commented Jun 25, 2015 at 18:02
  • Did you perhaps set the filter to or instead of and? Commented Jun 25, 2015 at 18:53
  • 1
    And you can not do it with a Calculated Column, because the Formula is only updated when a List Item is changed. So you have to do it with the filter in a View as Dan Henderson explains. Commented Jun 25, 2015 at 20:06

Try creating a view with filter where due date is less than [Today] - 5

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.