Quick Filter for Kanban Board that is 7 and 14 days out from due date...

[Mark Schlaudraff]

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.

[Randy · Accepted solution]

"RDD"  < -7d

"RDD" < -14d

[Randy]

You can also use -1w, -2w also.