order dates queries

JDE E1

Is there any way to exclude weekends and holidays when building a watchlist? I want to build a watchlist for F4211 that will show me any order with a promise delivery date equal to todays date plus 5 days. Todays date is Monday, August 8th. I should only see orders with a promise delivery date of August 14th, which is a Saturday. But considering we do not do anything on weekends, I want to exclude weekends so the next available day within 5 days of todays date would be August 16th.

Here's another scenario. I want to see any order with scheduled pick date of todays date +1. This would be any order with a scheduled pick date of tomorrow. Except on Friday I want to see orders with a scheduled pick date of Monday. I want to exclude weekends and holidays. Any ideas?