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?
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
is less than or equal to
Try creating a view with filter where due date is less than
[Today] - 5