Skip to main content

 

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 Dimension Day Of Weekboolean

  • 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 Dimension Dayboolean

 

 

Return type

Integer

 

Examples

Case

Results

Return Type

NETWORKDAYS(DATE(2020, 12, 2), DATE(2020, 12, 7), DayOfWeek)

3 with DayOfWeek Metric considering Saturday and Sunday as non-working days.

Integer

 

Excel equivalent: NETWORKDAYS

See also: DAYS

Be the first to reply!