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.
Contents
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 thestart_date
[holidays]
– Optional list of days to exclude from the workday count.
Video Tutorial
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
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.