Due Date Formula

New 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

2 Replies


Does the formula need to take weekend days into account?

yes... I need to include weekends @Hans Vogelaar