Description
Returns the number of working days between the two given dates. Optionally, you can exclude specific days of the week or holidays.
By default, all days of the week are considered as working days and no holidays are taken into account. This function can only be used with the native Pigment calendar and its time Dimensions. For more information on using the calendar, see Set up your calendar.
Syntax
NETWORKDAYS(Date From, Date To, Working Days, Holidays)
-
Working Days
defines which days of the week are working and non working days. User must use a Metric (or property) of the DimensionDay Of Week
⇒boolean
-
Date from
defines the first date to start counting from. -
Date to
defines the last date to count up to.
This date is not included in the count.
-
Holidays
defines which dates are holidays. User must use a Metric (or property) with the DimensionDay
⇒boolean
Return type
Integer
Examples
Case | Results | Return Type |
| 3 with |
|
Excel equivalent: NETWORKDAYS
See also: DAYS