Excel Function : WORKDAY.INTL

Download now!

Excel Function : WORKDAY.INTL

Category

Date and time

Description

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days

Microsoft Excel Reference Page

https://support.office.com/en-us/article/WORKDAYINTL-function-a378391c-9ba7-4678-8a39-39611a9bf81d

Syntax and Description of the WORKDAY.INTL Excel Function

The WORKDAY.INTL function in Excel calculates the number of workdays between two dates, based on an optional weekend parameter and an optional list of holidays. The syntax for the WORKDAY.INTL function is as follows: WORKDAY.INTL(start_date, days, [weekend], [holidays]) where start_date is the start date, days is the number of days, [weekend] is an optional parameter that specifies which days are considered weekends, and [holidays] is an optional parameter that specifies a list of dates that are considered holidays.

About WORKDAY.INTL Excel Function

The WORKDAY.INTL function returns a date that is a given number of workdays away from a start date, using criteria that you specify.