Related Functions:

The 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])

#### Arguments

Argument Description
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.

#### Examples

A B C
1 Mon 29-Dec-2014 Start date
2 151 Days to completion
3 Holidays
4 01-Jan-2015 New Years Day
5 19-Jan-2015 MLK Day
6 04-Jul-2015 Independence Day
7
8 Formula Result Notes
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