Skip to main content

networkdays - script and chart function

The networkdays function returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holiday.

Syntax:  

networkdays (start_date, end_date [, holiday])

Return data type: integer

Arguments:  

Arguments
Argument Description
start_date The start date to evaluate.
end_date The end date to evaluate.
holiday

Holiday periods to exclude from working days. A holiday period is stated as a start date and an end date, separated by commas.

Example: '25/12/2013', '26/12/2013'

You can specify more than one holiday period, separated by commas.

Example: '25/12/2013', '26/12/2013', '31/12/2013', '01/01/2014'

Holiday periods to exclude from working days. A holiday is stated as a string constant date. You can specify multiple holiday dates, separated by commas.