Documentation/Calc Functions/WORKDAY/en

Function name:
WORKDAY

Category:
Date and Time

Summary:
Calculates the date which is a specified number of workdays before or after a given start date. Holidays (or other non-work days) can be specified. Saturday and Sunday are assumed to be the weekend non-work days.

Syntax:
WORKDAY(StartDate; Days[; Holidays])

Returns:
Returns an integer which is the date-time serial number of the day that is a specified number of workdays before or after the given date. The returned value is formatted as a number by default, but you can apply other formats (such as Date) as needed.

Arguments:
StartDate is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the date for which the calculation is to be carried out.

Days is an integer value or a reference to a cell containing that value which is the number of workdays to be used as the offset in the calculation. A positive value is entered to get a result later than StartDate, a negative value is entered to get a result earlier than StartDate.

Holidays is a list of dates corresponding to holidays (or any other days) that are to be excluded from the count as non-work days. This list can be passed as a range of cells containing date-time serial numbers (possibly displayed in a date format). Alternatively, the list can be passed as an inline array containing either date strings (in quotation marks) or date-time serial numbers. If omitted, no holidays are assumed.


 * If StartDate is not a valid date expression, then WORKDAY reports a #VALUE! error.
 * WORKDAY ignores any time components of StartDate.
 * If Days is non-numeric, then WORKDAY reports a #VALUE! error.
 * If Days is a non-integer value, then WORKDAY truncates it to an integer.
 * If Holidays is passed as an inline array, an invalid argument error (Err:502) results if any entry of that array is not a date or a date-time serial number.
 * If Holidays is passed as a cell range and one of those cells contains data that is not a date or a date-time serial number, WORKDAY reports an invalid argument error (Err:502).

Details specific to WORKDAY function
WORKDAY normally considers Monday to Friday to be workdays, unless a particular day coincides with a specified holiday. The normal weekend days of Saturday and Sunday are taken as non-work days.

Calc's WORKDAY function does not support the optional Workdays parameter that is specified in ODF 1.2 but is compatible with Microsoft Excel’s function of the same name. If you need to specify a different working week, then use Calc’s WORKDAY.INTL function.

Related LibreOffice functions:
WORKDAY.INTL

ODF standard:
None.

Equivalent Excel functions:
WORKDAY