I am working on a solution to automate due dates for team tasks since they often put in weekend/holiday dates on accident.
For example: I have a task that needs to be completed in 21 calendar days and is starting October 22nd 2018, it would land on November 12th which is Veteran's Day here in the states. I'd want it to reflect that it needs to be completed on November 9th which is the last business day before the date due.
Another example would be 5 calendar days, say it was started Sept 5th 2018. 5 days (including the date started) would be Sept 9th, so I'd want the due date from the formula to be Sept 7th, 2018 (the last business day before that Sunday).
Is something like this even pos