WORKDAY Function

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.

Syntax: 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, 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.


Workday Function Examples

The spreadsheets below show simple examples of the Excel Workday function.


Examples of use of the Excel Workday Function


Excel Workday Function Results

In the above spreadsheets :

  • In the example in cell D2 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 examples in cells D3 and D4 the holidays array (in cells B2 – B4) is provided to the Workday function. Therefore the calculation excludes Saturdays and Sundays and the listed Christmas and New Year holidays.

Workday Function Errors

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

#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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>



clearPost Comment