SOLVED

New Contributor

# Need help with a formula

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)
Solution

# Re: Need help with a formula

Use

=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.

# Re: Need help with a formula

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