The WORKDAY function returns a date that is a supplied number of working days, excluding weekends and holidays, ahead of a given start date.
|start_date||The initial date from which to count the number of workdays.|
|days||The number of workdays to add onto start_date.|
|[holidays]||An optional argument, which specifies an array of dates, in addition to weekends, that are not to be counted as working days.|
Note: the start_date and [holidays] arguments should be input as either:
- References to cells containing dates, or
- Dates returned from formulas
If you attempt to input these date arguments as text, Excel may misinterpret them, due to different date systems, or date interpretation settings.
Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering varies across different computer systems.
|1||Mon 29-Dec-2014||Start date|
|2||151||Days to completion|
|4||01-Jan-2015||New Years Day|
|9||=WORKDAY(A2,A3)||Tue 28-Jul-2015||The date 151 workdays from the start date|
|10||=WORKDAY(A2,A3,A4:A6)||Thu 30-Jul-2015||The date 151 workdays from the start date, excluding holidays|
Usage note: WORKDAY can be used to calculate due dates, delivery dates, invoice dates, and other dates that should be determined based on a standard business calendar.
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if the start_date or any of the [holidays] are not valid dates, or the days argument is non-numeric|
|#NUM!||Occurs if the start_date plus the days argument results in an invalid date|
|#NAME?||Occurs when Excel does not recognise a function name. This may be because you have made a mistake when typing the WORKDAY function name|