Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / NETWORKDAYS
In This Topic
    NETWORKDAYS
    In This Topic

    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