WORKDAY

Calculates the date after a number of working days from a specified start date.

Parameter List

Syntax
WORKDAY(start_datenum_days
[holidays]
)
start_date

The date from which to begin counting. For example: 2022-04-06.

num_days

The number of working days to advance from start_date. If negative, counts backwards. For example: 10.

[optional] holidays

A range or array constant containing the dates to consider holidays. For example: B2:B6.

Examples

WORKDAY("2022-03-28", 5) returns 2022-04-04