Explanation
This formula uses the WORKDAY function to calculate an end date.
In column E, the WORKDAY function is used to calculate an end date.
Holidays are provided as thenamed range"holidays", G5:G9.
If holidays are not provided, the same formula returns a end date of January 2.
Note the WORKDAY functiondoes notcount the start date as a work day.
If your schedule has different requirements, it’s possible for you to substitute theWORKDAY.INTL functionfor WORKDAY.
Unlike the simplerWORKDAY function, WORKDAY.INTL can be…
