Automated audit schedule

I am wanting to determine future days (Mon-Fri) in an audit schedule based on the excluding the day of audit from last week eg, if Alan was audited on Monday last week then I want to set the date to be a random selection from the other 4 days. I also want to determine that if Alan was audited in the am last week, then it will be pm this week?

I hope this makes sense and I’d appreciate any assistance. Cheers.

By: Felicity

Leave a Reply

Your email address will not be published. Required fields are marked *