In the example shown, the formula in C6 is Next, the formula subtracts 1 day to get December 23, 2015, and the result goes into the WORKDAY function as the start date, with days = 1, and the range B9:B11 provided for holidays. WORKDAY then calculates the next business day one day in the future, taking into account holidays and weekends. If you need more flexibility with weekends, you can use WORKDAY.INTL.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.