How to filter reports using business days and NOT calendar days

Question

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 Answer

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 · Answer

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%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus

Sign up

Login with SSO

Login to the community

Login with SSO