I am making a workflow that tracks milestones before a project due date. The project due date could be any weekday, M-F. For example the input would be the project due date (ex Tuesday) and the task has to happen 3 business days before (ex Thursday). When I do a calculation of -3 days, it gives me Saturday.
Here are the results I want. Anyone have ideas how to make this happen?
Project Due Date (input) - Monday
Task Due (output) - Wednesday prior
Project Due Date (input) - Tuesday
Task Due (output) - Thursday prior
Project Due Date (input) - Wednesday
Task Due (output) - Friday prior
Project Due Date (input) - Thursday
Task Due (output) - Monday prior
Project Due Date (input) - Friday
Task Due (output) - Tuesday prior