WorkdaysBetween Function

Description:

The number of working days between two dates.

Returns:

Whole Number

Parameters:

Parameter	Data Type	Description
1	Date	The start date.
2	Date	The finish date.
3	Date*	List of dates that are non-working days. Optional.
4	Whole Number*	List of days of the week that represent non-working days, expressed as numbers from 1 (Sunday) to 7 (Saturday). Optional, if left blank, defaults to List( 1, 7 ).

Example:

When using functions inside a field, remember the field brackets:

{WorkdaysBetween( StartDate, EndDate )}

{WorkdaysBetween ( StartDate, EndDate, Collect(HolidayDate) )}

{WorkdaysBetween ( StartDate, EndDate, Collect(HolidayDate), ToInteger(NonWorkingWeekdays) )}

Expression	Result
WorkdaysBetween( Date( 2020, 12, 1 ), Date( 2020, 12, 26 ), List( Date( 2020, 12, 24 ), Date( 2020, 12, 25 ) ), List( 1 ) )	20

This article applies to: