To add or subtract workdays days to a date so that you can calculate a date in the future or past that skips weekends (customized) and holidays , you can use the WORKDAY.INTL function. Holidays and weekend are both optional.
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.
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.
By default, the WORKDAY function will exclude weekends (Saturday and Sunday). In this case, we have also supplied a list of 3 holidays that all fall in the date range being calculated, which means both the weekends and holidays will be excluded. The...
The WORKDAY.INTL function is based on the WORKDAY function , which is designed to add work days to a date. WORKDAY automatically excludes Saturday and Sunday, and optionally can exclude a list of custom holidays. The WORKDAY.INTL does the same thing...
The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.