Calc WORKDAY function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The WORKDAY function is used to calculate a date that is a specified number of working days before or after a given date, excluding weekends and optionally specified holidays.

Syntax

WORKDAY(start_date, days, [holidays])

The WORKDAY function syntax has the following arguments:

• start_date: Required. The date from which to start counting working days.
• days: Required. The number of working days to add (positive number) or subtract (negative number) from the start_date.
• holidays: Optional. A range or array of dates to exclude from the calculation as holidays.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc DATE function
• Calc DATEDIF function
• Calc DATESUB function
• Calc DAY function
• Calc DAYS function