The WORKDAY function calculates a workday a given number of days away from a date. You can optionally specify a list of holidays to exclude from the count. If your days, months, and years are in different cells, use the DATE function to combine them.

Syntax

=WORKDAY(start_date,days,[holidays])
  • start_date - The date from which to start counting the days.
  • days - The number of days to add to the start_date
  • [holidays] - Optional specification of which days are to be excluded from the count of work days.

Related functions

WEEKDAY - Returns the week number for a given date.

DAYS - Find the number of days between two dates.

NETWORKDAYS.INTL - Calculate the number of working days in between two days and exclude specified days as weekends.

NETWORKDAYS - Calculate the number of working days in between two days and exclude weekends.

WORKDAY.INTL - Like this function but with movable weekends.

Errors

#NUM - The inputs are numbers but are not valid dates. This could happen if you used the 35th day of November, "11/35/2018".

#VALUE! - The inputs are something that doesn't convert to a number such as "The other day" or "Yester-yester-day".

 Live examples in Sheets 

Go to this spreadsheet for the examples of the WORKDAY function that you can study and use anywhere you would like.