WORKDAY

The WORKDAY function returns the date that is N business days after (or before) a specified date.

Supported Product Scenarios

The WORKDAY function is supported in the following YiDA scenarios:

WORKDAY(start_time,days,holidays)

Attribute	Required	Description
start_time	Yes	The timestamp of the start time. You can directly use the value of a date component.
days	Yes	The number of business days. The maximum supported value is 50,000. Values exceeding this limit are treated as 0. Note: A positive value returns a date in the future. A negative value returns a date in the past. By default, a decimal value is treated as adding one day.
holidays	No	The dates to exclude from the calculation, in the format `yyyy-MM-dd`. You can specify multiple dates separated by commas (,). For example, you can include statutory and non-statutory holidays for various provinces, cities, autonomous regions, or countries/regions.

Return value type	Description
timestamp	The date that is N business days after (or before) a specified date. The value can be directly assigned to a date component.

As shown below, use the WORKDAY() function to calculate the point in time 15 business days later.