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