Navigation:  Formula Reference > Spreadsheet Formula Functions >

NETWORKDAYS

Previous pageReturn to chapter overviewNext page

 

This function returns the total number of complete working days between the start and end dates.

Syntax

NETWORKDAYS(startdate,enddate,holidays)

Arguments

This function has these arguments:

Argument

Description

startdate

Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

enddate

Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

holidays

[Optional] Range of dates to exclude from the calculation; if omitted, the calculation assumes no holidays and all weekdays are workdays

Data Types

Accepts numeric, string, or DateTime object data. Returns numeric data.

Examples

NETWORKDAYS(L4,L5)

NETWORKDAYS(R4C12,R1C1,R2C2)

 

See Also

NOW

WORKDAY