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.
start_date– The date from which to start counting the days.
days– The number of days to add to the
[holidays]– Optional list of days to exclude from the workday count.
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.
#NAME! – Google Sheets can’t understand the
#VALUE! – The inputs don’t convert to a number such as “The other day” or “Yester-yester-day.”
Live Examples in Sheets
Go to this spreadsheet for examples of the WORKDAY function that you can study and use anywhere you would like.
Consider using the IMPORTXML function to obtain a list of your local holidays from the web.