WORKDAY automatically excludes Saturday and Sunday, and optionally can exclude a list of custom holidays.
Values equal to 1 areexcluded,and days with zero values are treated normally.
Unlike the simplerWORKDAY function, WORKDAY.INTL can be…
Add days exclude certain days of week
To add days to a date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.) you can use the WORKDAY.INTL function with a special pattern code. In the example shown, the formula in C7 is: =WORKDAY.INTL(B7,7,"0101000") This formula adds 7 days to the date in B7, excluding Tuesdays and Thursdays.
