Spread Formula Reference
Formula Functions / Functions T to Z / WORKDAY
In This Topic
    WORKDAY
    In This Topic

    This function returns the number of working days before or after the starting date.

    Syntax

    WORKDAY(startdate,numdays,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)
    numdays Number of non-weekend or non-holiday days before or after the starting date; days in the future are positive and days in the past are negative; if not an integer, the number is truncated
    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

    WORKDAY(A2,A4)

    WORKDAY(R2C1,R5C5)

    WORKDAY(A1,A2,A5:A7)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    DATE | NETWORKDAYS | MONTH | Date and Time Functions