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.

networkdaysintl(StartDate, EndDate)

Output: Returns the number of working days between StartDate and EndDate.

networkdaysintl(date1,date2[,str_workingdays][,array_holiday])


ArgumentRequired?Data TypeDescription
date1YdatetimeStarting date to compare
date2YdatetimeEnding date to compare
str_workingdaysNstring

Seven-character string identifying the weekend days.

array_holidayNarrayAn array of string values representing the valid dates of holidays.

date1, date2

Date values can be column references or output of the DATE function or the TIME function.

Date values to compared in working days.

If date1 and date2 have a specified time zone offset, the function calculates the difference including the timezone offsets.

Required?Data TypeExample Value
YesDatetime (Column reference or date output of DATE or TIME function)LastContactDate

str_workingdays

A seven-character string identifying the days of the week that are working days.

Examples:

str_workingdaysWeekend days
'0000011'Saturday and Sunday (default)
'1000011'Monday, Saturday, and Sunday
'0000000'None.


Required?Data TypeExample Value
YesArray['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:

['2020-12-24','2020-12-25']
['2020/12/24','2020/12/25']

Required?Data TypeExample Value
YesArray['2018-12-24','2018-12-25','2018-12-31','2019-01-01']

Example - Date diffing functions