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 format 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:

or

- 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 does vary across different computer systems.


Workday Function Examples

The spreadsheets below show simple examples of the Excel Workday function. The format of the function is shown in the top spreadsheet and the results are shown below.

 Formulas:
Examples of use of the Excel Workday Function
 Results:
Excel Workday Function Results

In the above spreadsheets :

Note also that, as recommended by Microsoft, in all three calls to the Workday function, the start_date and [holidays] arguments have been supplied as either cell references or the return value from a function (in this case the Excel Date function).


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
or
- the supplied days argument is non-numeric
#NAME? -

Occurs when 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.

  +   Show How to Do This in Excel 2003:

  +   Show How to Do This in Excel 2007:

  +   Show How to Do This in Excel 2010 or Excel 2013:

Return to the Excel Date and Time Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net