WORKDAY Function – Google Sheets

The WORKDAY function calculates a workday that is 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 list of days to exclude from the workday count.

Video Tutorial

YouTube player

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 between two days and exclude custom weekends.

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

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

Errors

#NAME! – Google Sheets can’t understand the range_name.

#VALUE! – The inputs don’t convert to a number such as “The other day” or “Yester-yester-day.”

Examples

Three examples of the WORKDAY function returning different results with different inputs
WORKDAY Examples

Live Examples in Sheets

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

Notes

Consider using the IMPORTXML function to obtain a list of your local holidays online.