Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
WORKDAY.INTL

WORKDAY.INTL

Description

Returns a number representing the date that is the specified number of work days after the specified start date. Similar to WORKDAY(), but in WORKDAY.INTL() you can specify which days of the week are weekend days.

Syntax

WORKDAY.INTL(
start_date
,
days
, [
weekend
], [
holidays
])
  • start_date
    : The date to start counting from. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
  • days
    : The number of work days to add to the start_date.
  • weekend
    : The code specifying which days of the week are weekend days. The code can be numerical, as described in the table below, or a string, where a 0 represents a weekday and a 1 represents a weekend day. Example: "0000111" specifies that Friday, Saturday, and Sunday are weekend days.
    Code
    Description
    1
    Saturday and Sunday
    2
    Sunday and Monday
    3
    Monday and Tuesday
    4
    Tuesday and Wednesday
    5
    Wednesday and Thursday
    6
    Thursday and Friday
    7
    Friday and Saturday
    11
    Sunday only
    12
    Monday only
    13
    Tuesday only
    14
    Wednesday only
    15
    Thursday only
    16
    Friday only
    17
    Saturday only
  • holidays
    : The list of dates to exclude from the work day count. Workday recommends using a cell reference to specify the dates instead of entering them as text, to ensure reliable results.

Example

Formula
Result
=WORKDAY.INTL("11/20/2017",30)
1/1/2018
=WORKDAY.INTL("11/20/2017",27,1,{"11/23/2017", "11/24/2017", "12/25/2017"})
1/1/2018
=WORKDAY.INTL("11/20/2017",30,"0000100",{"11/23/2017", "11/24/2017", "12/25/2017"})
12/27/2017

This content is not part of the Workday Administrator Guide.