WORKDAY automatically excludes weekends, and can also exclude holidays if provided as a range of dates.
For holidays, we provide thenamed range"holidays", which includes the dates in G5:G9.
The dates will not be included as workdays.
If holidays are not provided, the same formula returns a start date of December 24.
Note the WORKDAY function does not count the start date as a workday.
Custom workdays
If your schedule requires custom workdays (i.e.
weekdays are not Monday-Friday) you’ve got the option to substitute theWORKDAY.INTL functionfor WORKDAY.
Unlike the simplerWORKDAY function, WORKDAY.INTL can be…
