WORKDAY
Returns the end date after a specified number of working days
Usage examples
-
WORKDAY("2/23/23", 10, ["2023-2-24", 44993]) -
WORKDAY(tableA.fieldB, tableA.fieldC, ["2023-2-24"])
Syntax
WORKDAY ( start_date, num_days, [ holidays ] )
-
start_date- the date from which to begin counting -
num_days- the number of working days to advance from start_date, if negative, counts backwards -
holidays- a range or array constant containing the dates to consider holidays
Returns
number - the end date after number of working days after the specified date.