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

You can experiment with this function in the test box below.

Test Input

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

FEEDBACK