Add days excluding specific days of week

This tutorial shows how to add days excluding specific days of a week through the use of an Excel formula, with the WORKDAY.INTL function

Excel

Add days excluding specific days of week using WORKDAY.INTL function

EXCEL FORMULA 1. Add days excluding specific days of week

EXCEL

Hard coded formula

Add days excluding specific days of week

Cell reference formula

=WORKDAY.INTL(B5,10,"1001000",$H$5:$H$12)

=WORKDAY.INTL(B8,$C$5,D8)

GENERIC FORMULA

=WORKDAY.INTL(date,days,exclude_days)

ARGUMENTS
date: A date that you want to add days to.
days: Number of days that you want to add to the date.
exclude_days: Days of the week that you want to exclude.

GENERIC FORMULA

=WORKDAY.INTL(date,days,exclude_days)

ARGUMENTS
date: A date that you want to add days to.
days: Number of days that you want to add to the date.
exclude_days: Days of the week that you want to exclude.

EXPLANATION

This formula uses the WORKDAY.INTL function to add days to a date, excluding specific days of a week.

Click on either the Hard Coded or Cell Reference button to view the formula that has the number of days to add to a date and the pattern code directly entered into the formula or referenced to specific cells.

In this example the formula adds a number of days to a specific date, excluding certain days of a week through the use of a WORKDAY.INTL function. The formula uses a specific pattern code, which is a seven digit code that represented each day of a week, starting from Monday (first digit) to Sunday (last digit). The pattern comprises either 0 or 1, where values equal to 1 represent the day of the week that is to be excluded and those equal to 0 are to be treated normally.

The first line in this example adds 10 days to 3 February 2019, excluding Mondays and Thursdays, therefore given that Monday and Thursday are the first and forth days of the week, respectively, the value of one is used as the first and forth values in the pattern code (1001000).