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.
Forum Discussion
Solved
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?
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.
HansVogelaar Thank you so much! This is working.
