> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# NETWORKDAYS

> The NETWORKDAYS function calculates the number of working days between two dates. It supports multiple YiDA scenarios, including Form, workflow design, and integration & automation. By setting the start time, end time, and an optional list of holidays, you can accurately calculate the number of working days within a specified date range.

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.

* Form (main table fields)
* Form (business association rules)
* Form (validation)
* Workflow design (validation rules)
* Workflow design (association actions)
* Integration & automation
* Workflow node
* Connector

## Format

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
WORKDAY(start_time,end_time,holidays)
```

## Attribute Description

| **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.<br />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.<br />For example, you can specify statutory and non-statutory holidays for various provinces, cities, autonomous regions, or countries/regions. |

## Return Value

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

## Example

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