How to filter reports using business days and NOT calendar days

[LauraHa1]

I'm trying to figure out how to make report filters use business days (M - F) and not calendar days. Our WF schedule is already set up for work hours to only be M - F.

For example, I want to show tasks with due dates within the next 2 days, but the report doesn't take weekends into account. So if I have a filter of Due Date Between $$TODAY+2d and $$TODAY+1d , it works fine, until we get to the end of the week. On Thursday, it won't show any tasks due the following Monday. It counts the weekend even though our company WF doesn't list Sat and Sun as work days.

Is there a workaround for this?

[EricMa · Accepted solution]

This is a longstanding source of irritation for me and my team. Workfront (surprisingly) doesn't support this, but I invite you to upvote my idea to add "workdays" as a date-based wildcard for filtering: https://one.workfront.com/s/idea/0870z000000PSbwAAG/detail

[KellyBu]

Yes! I just figured this out:

WEEKDAYDIFF(date2, date1)

Here is a link to some other helpful formulas:

https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...

[GregoryLa]

Hi Kelly - I love this! Can you please share your report and/or all of the filters you are using on this report?

Thank you!