WORKDAYINTL Function
Calculates the work date that is before or after a start date, as specified by a number of days. You can also specify which days of the week are working days and a list of holidays via parameters.
Input can be a column reference or the output of the DATE or TIME function.
See DATE Function.
See TIME Function.
The first value is used as the baseline.
The second value is the number of days before or after the start date.
If the second value is negative, the function returns the number of days before the start date.
Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.
Basic Usage
workdayintl(StartDate, 5,'0000001')
Output: Returns the working date that is five days after the StartDate
, assuming that every day except for Sunday is a working day.
Syntax and Arguments
workdayintl(date1,numDays<span>[</span><span>,</span><span>str_workingdays]</span>[<span>,</span>array_holiday])
Argument  Required?  Data Type  Description 

date1  Y  datetime  Starting date to compare 
numDays  Y  integer  Number of days before or after starting date 
str_workingdays  N  string  Sevencharacter string identifying the weekend days. 
array_holiday  N  array  An array of string values representing the valid dates of holidays. 
For more information on syntax standards, see Language Documentation Syntax Notes.
date1
Date value can be a column reference or output of the DATE
function or the TIME
function.
For more information, see DATE Function.
For more information, see TIME Function.
Usage Notes:
Required?  Data Type  Example Value 

Yes  Datetime (Column reference or date output of DATE or TIME function)  LastContactDate 
numDays
An Integer that defines the number of working days distance from the start date. The function returns the start date plus or minus the number of working days represented in this Integer.
If the integer is less than zero, the number of working days are counted backward from the start date.
Usage Notes:
Required?  Data Type  Example Value 

Yes  integer  10 
str_workingdays
A sevencharacter string identifying the days of the week that are working days.
String value must be seven characters long and contain only
0
or1
characters. All other values are ignored.First character in the string represents Monday and last character in the string represents Sunday.
If the string is not specified, then a Monday  Friday workweek is used.
Examples:
str_workingdays  Weekend days 

'0000011'  Saturday and Sunday (default) 
'1000011'  Monday, Saturday, and Sunday 
'0000000'  None. 
Usage Notes:
Required?  Data Type  Example Value 

Yes  Array  ['1000011'] 
array_holiday
An array containing the list of holidays, which are factored in the calculation of working days.
Values in the array must be in either of the following formats:
['20201224','20201225'] ['2020/12/24','2020/12/25']
Usage Notes:
Required?  Data Type  Example Value 

Yes  Array  ['20181224','20181225','20181231','20190101'] 
Examples
Tip
For additional examples, see Common Tasks.
Example  Date diffing functions
This example demonstrates how to calculate the number of days between two input dates.
Functions:
Item  Description 

DATEDIF Function  Calculates the difference between two valid date values for the specified units of measure. 
NETWORKDAYS Function  Calculates the number of working days between two specified dates, assuming Monday  Friday workweek. Optional list of holidays can be specified. 
NETWORKDAYSINTL Function  Calculates the number of working days between two specified dates. Optionally, you can specify which days of the week are working days as an input parameter. Optional list of holidays can be specified. 
WORKDAY Function  Calculates the work date that is before or after a start date, as specified by a number of days. A set of holiday dates can be optionally specified. 
WORKDAYINTL Function  Calculates the work date that is before or after a start date, as specified by a number of days. You can also specify which days of the week are working days and a list of holidays via parameters. 
Source:
The following dataset contains two columns of dates.
The first column values are constant. This date falls on a Monday.
Date1  Date2 

20200309  20200313 
20200309  20200306 
20200309  20200316 
20200309  20200323 
20200309  20200410 
20200309  20210310 
Transformation:
The first transformation calculates the number of raw days between the two dates:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  datedif(Date1, Date2, day) 
Parameter: New column name  'datedif' 
This step computes the number of working days between the two dates. Assumptions:
Workweek is Monday  Friday.
There are no holidays.
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  networkdays(Date1, Date2, []) 
Parameter: New column name  'networkDays' 
For some, March 17 is an important date, especially if you are Irish. To add St. Patrick's Day to the list of holidays, you could add the following transformation:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  networkdays(Date1, Date2, ['20200317']) 
Parameter: New column name  'networkDaysStPatricks' 
In the following transformation, the NETWORKDAYSINTL function is applied so that you can specify the working days in the week:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  networkdaysintl(Date1, Date2, '1000011', []) 
Parameter: New column name  'networkDaysIntl' 
The following two functions enable you to calculate a specific working date based on an input date and integer number of days before or after it. In the following, the date that is five working days before the Date2
column is computed:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  workday(Date2, 5) 
Parameter: New column name  'workday' 
Suppose you wish to factor in a fourday workweek, in which Friday through Sunday is considered the weekend:
Transformation Name 


Parameter: Formula type  Single row formula 
Parameter: Formula  workdayintl(Date2, 5,'0000111') 
Parameter: New column name  'workdayintl' 
Results:
Date1  Date2  workdayintl  workday  networkDaysIntl  networkDaysStPatricks  networkDays  datedif 

20200309  20200313  20200305  20200306  4  5  5  4 
20200309  20200306  20200227  20200228  null  null  null  3 
20200309  20200316  20200315  20200309  4  6  6  7 
20200309  20200323  20200312  20200316  8  10  11  14 
20200309  20200410  20200402  20200403  20  24  25  32 
20200309  20210310  20210302  20210303  210  262  263  366 