Breadcrumbs

WORKDAY

Definition

Calculates the number of working days from a specified start date.

Sample Usage

WORKDAY(DATE(1969,7,20), 4, A1:A10)

WORKDAY(A2, 10)

WORKDAY(40909, 4, B2:B17)

WORKDAY(40909, 30, {40909,40924})

Syntax

WORKDAY(start_date, num_days, [holidays])

  • start_date - The date from which to begin counting.

  • num_days - The number of working days to advance from start_date. If negative, counts backwards.

    • If num_days is not an integer, the decimal part is truncated. That is, WORKDAY(A2,1.9) is equivalent toWORKDAY(A2,1).

  • holidays - [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.

    • The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE, DATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

    Notes

    • WORKDAY does not autoconvert number formats in the same way that Excellentable does upon direct entry into cells. Therefore, WORKDAY(10/10/2000,4) is interpreted as WORKDAY(0.005,4), where the provided date is the quotient of 10 divided by 10 divided by 2000.

    • WORKDAY calculates a number of working days after a given date. To calculate the number of working days between two dates, use NETWORKDAYS.

    • WORKDAY works similarly to WORKDAY.INTL but only treats Saturday and Sunday as the weekend. UseWORKDAY.INTL to use other days of the week as the weekend.

    See Also

    WORKDAY.INTL: Calculates the date after a specified number of workdays excluding specified weekend days and holidays.

    TO_DATE: Converts a provided number to a date.

    NETWORKDAYS: Returns the number of net working days between two provided days.

    N: Returns the argument provided as a number.

    DATEVALUE: Converts a provided date string in a known format to a date value.

    DATE: Converts a provided year, month, and day into a date.

 

In order to use the WORKDAY formula, start with your edited Excellentable

image2016-7-18 15:42:27.png

 

image2016-7-18 15:41:56.png

By adding the values you would like to calculate, Excellentable generates the outcome:

 

There were errors rendering macro:

  • An unknown error occurred.