WorkdaysBetween Function
Description:
The number of working days between two dates.
note
This function is similar to the Excel function NETWORKDAYS.INTL.
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 |
Related Content
-
Date Functions
Format:
Article,
1 min read