Explanation
By default, the WORKDAY.INTL function will exclude weekends (Saturday and Sunday). In this case, however, we have supplied 11 for this argument, which means "Sunday only" (see: full list weekend codes).
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.
No holidays | Holidays provided |
---|---|
Wed, 23-Dec-2015 | Wed, 23-Dec-2015 |
Thu, 24-Dec-2015 | Thu, 24-Dec-2015 |
Fri, 25-Dec-2015 | Fri, 25-Dec-2015 |
Sat, 26-Dec-2015 | Sat, 26-Dec-2015 |
Sun, 27-Dec-2015 | Sun, 27-Dec-2015 |
Mon, 28-Dec-2015 | Mon, 28-Dec-2015 |
Tue, 29-Dec-2015 | Tue, 29-Dec-2015 |
Wed, 30-Dec-2015 | Wed, 30-Dec-2015 |
Thu, 31-Dec-2015 | Thu, 31-Dec-2015 |
Fri, 01-Jan-2016 | Fri, 01-Jan-2016 |
Sat, 02-Jan-2016 | Sat, 02-Jan-2016 |
Sun, 03-Jan-2016 | Sun, 03-Jan-2016 |