Investment Studio > Expressions > Functions > Date & Time > NETWORKDAYS
integer networkdays(date start_date, date end_date, date array holidays = {})
Returns the number of whole working days from start_date to end_date. Weekends and any dates contained in the (optional) holidays array are not counted.
Automatic type conversion allows the use of date strings as arguments instead of explicit date values.
Example
Assuming standard US date format settings,
=networkdays("2/1/2002", "2/28/2002")
equals 20, while
=networkdays("2/1/2002", "2/28/2002", {"2/14/2002", "2/15/2002", "2/16/2002"})
equals 18 (not 17 since the last "holiday", 2/16/2002, was a Saturday and thus excluded from both counts anyway).