Need help with a formula

New Contributor

Hello,  I am brand new here and I am trying to figure out a formula that will do the following:

My timelines require me to count consecutive days but the final day cannot end on a weekend or holiday.  I am not counting just business days so the WORKDAY or WORKDAYS.INT OR NETWORKDAYS.INT seem to be working.  


For example: 

Mutual Acceptance = X

Day 1 = starts counting the next day (this seems to work automatically when counting consecutive days)

Contingency 1 is due in 17 consecutive days but it cannot end on a weekend or holiday (I have a list of the state holidays)


Does anyone have a formula?

2 Replies
best response confirmed by Sergei Baklan (MVP)





=WORKDAY(AcceptanceDate+16, 1, HolidayRange)


The formula first adds 16 consecutive days (including weekends and holidays), then uses the WORKDAY function to go to the next business day.

@Hans Vogelaar Thank you so much!  This is working.