In the example, the formula in D6 is: This formula adds 7 workdays days to Tuesday, Dec 22. Three holidays are supplied and weekends are set using 11 for the weekend argument, which means “Sunday only”. The result is Wednesday, December 30, 2015. We have also supplied a list of 3 holidays that all fall in the date range being calculated, which means that the holidays and Sundays will be excluded. The following table shows which dates are excluded with and without holidays provided (exluded dates are shaded gray). The final dates returned by WORKDAY are highlighted in yellow.

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.