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