Due Date Formula

Copper Contributor

Good Morning, I need a due date formula that excludes a 6.5-hour window from 2330 till 0600 as well as a selected list of days. The goal is to have a formula that will look at a start date and span hours that will give a target date that excludes nonwork hours and specific days. (our observance of a given holiday may not be the same "Holiday" function).


Thank you

1 Reply


Does the formula need to take weekend days into account?