networkdays() Function

Returns the number of working days between two specified dates.

Syntax

networkdays( starting date, ending date, [holidays] )

starting_date: (Date) The starting date.

ending_date: (Date) The ending date.

holidays: (Date) A list of holidays not counted as workdays.

Returns

Integer

Notes

An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}.

Examples

networkdays(date(2011,12,13),date(2011,12,20)) returns 6

Open in Github Built: Fri, Nov 04, 2022 (07:10:52 PM)

On This Page

FEEDBACK