Google Sheets Function

WORKDAY

Returns a date that is the indicated number of working days before or after a start date.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

WORKDAY(start_date, days, [holidays])

The WORKDAY function calculates a future or past date by excluding weekends and optional holidays. It is commonly used for project scheduling and calculating delivery deadlines that must fall on business days.

Arguments

start_daterequiredThe date from which the calculation begins.
daysrequiredThe number of non-weekend and non-holiday days before or after start_date.
holidaysoptionalAn optional list of dates to be excluded from the working calendar.

Examples

=WORKDAY("2023-10-01", 5)

Result: 2023-10-06

Calculates the date 5 working days after October 1, 2023, skipping the weekend.

FAQ

Does WORKDAY count the start date as a working day?

No, the function starts counting from the day after the start_date provided.

Related functions

NETWORKDAYS WORKDAY.INTL DATE