Spread Formula Reference
NETWORKDAYS
Formula Functions > Functions M to Q > NETWORKDAYS

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)

Version Available

This function is available in product version 2.0 or later.

See Also

WORKDAY | NOW | Date and Time Functions