And what if Friday was a holiday? Now you want to go back to Thursday when running this on Monday?
What if Monday was a holiday and you run this on Tuesday? Go back one day as you seem to be asking, or go back 2 working days to Friday?
Or is your situation as simple as you made it out to be? This is a commonly asked question and if you google ms access exclude weekends and holidays you'll get millions of hits.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.