WORKDAY.INTL Function in Excel

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:

WORKDAY.INTL Function in Excel 0

 

Example of WORKDAY.INTL Function in Excel with holiday list and weekends

Formula

WORKDAY.INTL Function in Excel 1

  • 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

WORKDAY.INTL Function in Excel 2

 

Example of WORKDAY.INTL Function in Excel excluding holiday list and Sunday

Formula

WORKDAY.INTL Function in Excel 3

  • 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

Result

WORKDAY.INTL Function in Excel 4

previous-small WORKDAY.INTL Function in Excel                                                                                                                next_small WORKDAY.INTL Function in Excel