WORKDAY.INTL function returns a date that is before or after a provided number of workdays. The function allows specifying which days of the week are weekends and excluding specified holidays.

# Excel WORKDAY.INTL function

## Generic Formula

**=WORKDAY.INTL(start_date,workdays,[weekend],[holidays])**

**weekday **is an optional argument. It indicates which weekdays are weekend days. This value can be number. For example:

**weekend **can also be a string value which are seven characters “” and “1” only. Seven of these characters represent seven weekdays (Monday, Tuesday, Wednesday Thursday, Friday, Saturday and Sunday). “0” represents the workday, and “1” represent the non-workday. For example:

0001100: weekend days are Thursday and Friday

1100000: weekend days are Thursday and Friday

0000111: weekend days are Friday, Saturday and Sunday.

1111111: is an invalid string

**holiday **is optional. A set of dates that are as non-workdays.

## Example

Considering the examples below:

*Figure 1 – Excel WORKDAY.INTL Function*

## Explanation

The formula in C7 is

returns Jan 11, 2019, is the date after 30 workdays from Dec 1, 2018. **=WORKDAY.INTL(B1,30) ****weekend** is omitted from the function which defaults weekend days are Sat and Sun

The formula in C8 is

counts the **=WORKDAY.INTL(B1,30,1,B2:B4)****holidays **array B2:B4. You cannot omit **weekend** from the function if you want to indicate **holidays **argument**. **Choose 1 to default weekend days are Sat and Sun. ** **

The formula in C9 is

specifies the weekend days are Fri, Sat, and Sun by the string **=WORKDAY.INTL(B1,30,"0000111") ****0000111**.

## Notes:

WORKDAY.INTL function can return a date in the past if **workdays **is a negative number.

## Leave a Comment