# The Excel WORKDAY Function

Related Functions:
NETWORKDAYS
WORKDAY.INTL

## Basic Description

The Excel Workday function returns a date that is a supplied number of working days (excluding weekends and holidays) ahead of a given start date.

The syntax of the function is:

WORKDAY( start_date, days, [holidays] )

where the arguments are as follows:

 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 that 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, there is a risk that Excel may misinterpret them, due to different date systems, or date interpretation settings.

## Workday Function Examples

In the spreadsheets below, the Excel Workday function is used to find a date that is 25 work days after 01-Dec-2015. The first example (in cell A7) only excludes weekends from the calculation, while the second example (in cell A8) excludes weekends and a supplied list of holidays.

 Formulas: Results:

Note that, in the above spreadsheets:

• In the example in cell A7 the [holidays] array has been omitted. Therefore the calculation excludes Saturdays and Sundays but includes all other weekdays, including the holidays at Christmas and New Year.
• In the example in cells A8 the [holidays] array (in cells B2 - B4) is provided to the Workday function. Therefore the calculation excludes Saturdays and Sundays and the specified Christmas and New Year holidays.

Note also that, as recommended by Microsoft, both calls to the Workday function, the start_date and [holidays] arguments have been supplied as cell references.

Further examples of the Excel Workday function can be found on the Microsoft Office website.

## Workday Function Errors

If you get an error from the Excel Workday function this is likely to be one of the following:

Common Errors
 #NUM! - Occurs if the supplied start_date plus the supplied days argument results in an invalid date. #VALUE! - Occurs if either:The supplied start_date or any of the values in the supplied [holidays] array are not valid dates;The supplied days argument is non-numeric. #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 into Excel.Alternatively, this could be because the Analysis ToolPak add-in is not enabled in your Excel. You will need to enable this if you want to use the Excel Workday function.