Returns a date that is the indicated number of working days before or after a start date.
Syntaxis
WORKDAY(start_date, days, [holidays])Argumenten
start_datevereist
The date from which the calculation begins.
daysvereist
The number of non-weekend and non-holiday days before or after start_date.
holidaysoptioneel
An optional list of dates to be excluded from the working calendar.
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.
=WORKDAY("2023-10-01", 5)→2023-10-06Calculates the date 5 working days after October 1, 2023, skipping the weekend.
Enter the start date
Type the start date directly or reference a cell containing a valid date.
Specify the number of days
Enter a positive number for future dates or a negative number for past dates.
No, the function starts counting from the day after the start_date provided.