Google Sheets-funktion

WORKDAY

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

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

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.

Argument

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

Exempel

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

Resultat: 2023-10-06

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

Vanliga frågor

Does WORKDAY count the start date as a working day?

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

Relaterade funktioner

NETWORKDAYS WORKDAY.INTL DATE