I am running a long workflow from Order to Shipment and each stage has specific number of days assigned to complete their task. I am using this table to calculate Target Completion date for each step(or Task) in the workflow.
I take current Date/Time and Use Add Days functtion to Add number of days assigned for the next Task and move to next Step.
The problem I am experiencing with ADD DAYS function is that it adds Calendar Days to the Date and sometimes task deadlines fall on a Saturday or Sunday which is not acceptable. We just want to make sure it always add Business days to a date instead of calendar days.
Need helpf, if there is a different function I shall use or a an app?
Thanks