# WORKDAY

Calculates the end date after a specified number of working days.

### 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 to `WORKDAY(A2,1)`.
• `holidays` - [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.

### Notes

• `WORKDAY` does not autoconvert number formats in the same way that Google Sheets 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 the end date after a specified number of working days. 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. Use `WORKDAY.INTL` to use other days of the week as the weekend.

`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 year, month, and day into a date.

### Examples

Returns the end date after a specified number of working days.

Search
Clear search
Close search