networkdays() Function

Function

networkdays( starting_date, ending_date, holidays )

Returns the number of working days between two specified dates.

Parameters

Keyword Type Description

starting\_date

Date

The starting date.

ending\_date

Date

The ending date.

holidays

Date

A list of holidays not counted as workdays.

Returns

Integer

Usage considerations

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

Open in Github Built: Fri, Sep 17, 2021 (04:05:09 PM)

On This Page

FEEDBACK