Description

Returns the number of working days between the two given dates. Optionally, user can exclude specific days of the week or holidays.

Note: by default, all days of the week are considered as working days and no holidays are taking into account.

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 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 Dimension Day⇒ boolean

Return type

Integer

Examples

Excel equivalent: NETWORKDAYS

See also: DAYS