Filter for Business Days? - Expression Assistance

[mykrobinson]

I need to create a slice that shows patients who are marked for TCM (transitional care management). that part is easy enough, but i need to create different "states" of TCM patients based on various criteria, most of which are easy enough for me to do. The one thing that is throwing me, though, is filtering based on time from the [Latest Discharge Date] value, but have it based on business days, which here would be monday through friday.

so if my current formula for the YELLOW TCM state is:

AND(
NOT([Status]="Deceased"),
NOT([In Hospital]="True"),
CONTAINS([Follow Up],"TCM"),
[Latest Discharge Date]<=(TODAY()-2)
)

what are my options for the date part to only count for monday through friday? then of course there's the issue of holidays, but let's start with M-F

[WillowMobileSys]

Take a look at the WORKDAY() function.  Does it give you want you need?

[mykrobinson]

Didn't know that was a thing, thank you! I shall dig into that after some much needed breakfast.