Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Due date PRIOR to weekend or holiday
I have a one date upon which all other due dates are calculated.
We have holidays set up for the account.
I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networkday functions fall on the following week day, which doesn't work for me.
This formula calculates if the date falls on a weekend. If not a weekend, 45 days, if a Sunday 43 days, if a Saturday 44 days. How would I add in Holidays?
=IF(WEEKDAY([Start Date]17 + 45) = 1, [Start Date]17 + 43, IF(WEEKDAY([Start Date]17 + 45) = 7, [Start Date]17 + 44, [Start Date]17 + 45))
If the start date is 5/20/17, adding 45 days causes it to fall on 7/4/17. Since 7/3 and 7/4 are company holidays, I need the 45 day due date to be 6/30/17, the previous workday.