Hi Gavin -
Here's your solution:
Start by making your 5 fields as follows:
Original Date field: Nothing special. This is the 'driver' or 'input' field.
OriginalDayOfWeek field:
Select WkDaySerial field: ;
...Settings: Set Options 1,2,3,4,5
...Conditional Rules:
(etc...)
Algorithm for 7th Workday field:
Copy and paste this equation:
{Select WkDaySerial}==1? 9 : ({Select WkDaySerial})==2? 9: ({Select WkDaySerial})==3? 9: ({Select WkDaySerial})==4? 11: ({Select WkDaySerial})==5? 11: 0
Output Date (Due Date) field:
this is the result for 9/18/2019:
if you have more questions let me know!
Jonathan
432-978-4985