The WORKDAY.INTL Function in Excel takes a date as input and returns the nearest working day in the future or past, based on days value you provide. You can also exclude holidays. It is similar to WORKDAY Function in addition to that WORKDAY.INTL Function allows you to customize which days are considered weekends (non-working days).
Syntax for WORKDAY.INTL Function in Excel
WORKDAY.INTL (start_date, days, [weekend], [holidays])
start_date – The start date.
days – working days before or after start_date.
weekend – [optional] Setting for which days of the week should be considered weekends.
holidays – [optional] A list of one or more dates that should be considered non-work days.
Values for weekend optional Argument:
Example of WORKDAY.INTL Function in Excel with holiday list and weekends
Formula
- 1 supplied as input to weekend argument which denotes Saturday and Sunday as weekends
- 23rd working day (excluding weekend) and Excluding list of holidays from Jan-1-2017 is Feb-3-2017
Result
Example of WORKDAY.INTL Function in Excel excluding holiday list and Sunday
Formula
- 11 supplied as input to weekend argument which denotes only Sunday as weekend.
- 23rd working day (excluding sunday) and Excluding list of holidays from Jan-1-2017 is Jan-30-2017