I'm trying to build a filter that will show me 7 Days Out from our set due date and 14 days out from our set due date, but I only want working days, do not want to include weekends.
I currently have the following Filters and they work:
Past Due: "Required Due Date" < startOfDay()
Due Within Next 3 Months: "Required Due Date" <= endOfMonth(3)
Due By End Of 2020: "Required Due Date" <= endOfYear(1)
What I'm trying to build is:
7 Days from Required Due Date and 14 Days from Required Due Date, but without including weekends.
