WORKDAY function

WORKDAY returns a date number that can be formatted as a date. You then see the date of a day that is a certain number of workdays away from the start date.

Syntax

WORKDAY(start date, days, holidays)

  • start date is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.
  • days is the number of workdays. This argument has a positive value for a result after the start date, or a negative value for a result before the start date.
  • holidays is a list of optional non-working days. Enter a cell range in which the holidays are listed individually.

Example

To return the date that comes 17 workdays after 1 December 2001, enter the start date "12/1/2001" in cell C3 and the number of workdays in cell D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "12/24/2001", "12/25/2001", "12/26/2001", "12/31/2001", "1/1/2002".

=WORKDAY(C3,D3,F3:J3) returns 12/28/2001. Format the serial date number as a date.