I'm trying to create a highlight criteria in my saved search that is weekday only. The highlight rules I have attached below covers sales orders that are highlighted based on when they should be sent out, and also potential tardiness. It generally works. Unfortunately, the options don't allow me to select only weekdays so our Monday report turns into a sea of red/orange. Wondering how to build a formula similar to the structure I have, that incorporates weekdays instead of calendar week.

You might be able to use a relate date filter if your needs are simple and you only need to look back or forward a week or so

The orders cover a total span of 5 business days prior to current date. Orders entered on Friday will show up Orange since 3 days has passed. In reality, only half a business day has passed, and it should be yellow or green.

orders created between the end of the last business week and the start of this business week is last weekend

Ahh I see where you're going with this. So basically I cover a span of 5-10 business days, and it won't count weekends since I selected business week, correct?

you can use the same span