NETWORKDAYS

The NETWORKDAYS function calculates the number of working days between two dates.

Supported Product Scenarios

The NETWORKDAYS function is supported in the following YiDA scenarios.

WORKDAY(start_time,end_time,holidays)

Attribute	Required	Description
start_time	Yes	The timestamp of the start time. You can directly use the value of a Date component.
end_time	Yes	The timestamp of the end time. You can directly use the value of a Date component. The interval between the start time and the end time must not exceed 50,000 days. Otherwise, an empty value is returned.
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 specify statutory and non-statutory holidays for various provinces, cities, autonomous regions, or countries/regions.

Return value type	Description
Numerical	The number of working days returned.

As shown below, use the NETWORKDAYS() function to calculate the number of working days between two dates.