---
title: NETWORKDAYS
description: Calculate working days between dates using the NETWORKDAYS function. Exclude weekends and optimize project planning with date calculations.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# NETWORKDAYS

The NETWORKDAYS function in Infoveave calculates the number of working days between two dates, excluding weekends.

## Applicable to

Calculated Columns

## Return Value

 The NETWORKDAYS function returns an integer representing the number of working days between the start and end dates, excluding weekends.

## Remark

* The NETWORKDAYS function is useful for calculating the duration of projects, activities, or any activities that occur only on working days.
* The weekend parameter is optional. If not provided, it considers Saturday and Sunday as the weekends by default.
* The NETWORKDAYS parameter for weekends must be between 1 and 17, and the weekends cannot be a decimal value.

## Syntax

```
NETWORKDAYS(start, end, weekends)
```

<Aside type="tip">
You can call in the system defined date function start date and end date as `@StartDate` and `@StartDate` respectively.
</Aside>

 Steps to Use NETWORKDAYS Function

<Steps>
1. Write the NETWORKDAYS function. For instance ```NETWORKDAYS(start, end, weekend)```
2. Replace `start` with the start period. You can also call in `@StartDate` function.
3. Replace `end` with the end period required. You can also call in `@EndDate` function.
4. Replace `weekend` with the value required.
5. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>

## DATEDIFF in Calculated Columns



| Parameter | Description |
|---|---|
| Start | The start date of the period you want to calculate the difference from. |
| End | The end date of the period you want to calculate the difference to. |
| Weekend | A list of dates representing holidays or non-working days that should be excluded from the count of working days.<br/> 1 or omitted. Consider both Saturday and Sunday as the weekends.<br/> 2. Sunday and Monday are considered the weekends.<br/> 3. Monday and Tuesday are considered the weekends.<br/> 4. Tuesday and Wednesday are considered the weekends.<br/> 5. Wednesday and Thursday are considered the weekends.<br/> 6. Thursday and Friday are considered the weekends.<br/> 7. Friday and Saturday are considered the weekends.<br/> 11. Only Sunday is considered the weekend.<br/> 12. Only Monday is considered the weekend.<br/> 13. Only Tuesday is considered the weekend.<br/> 14. Only Wednesday is considered the weekend.<br/> 15. Only Thursday is considered the weekend.<br/> 16. Only Friday is considered the weekend.<br/> 17. Only Saturday is considered the weekend. |

## Example 1

Assume you have the following dates <br/>

**Start Date 01-05-2024** and **End Date 31-05-2024**
To calculate the number of working days between these two dates, excluding weekends, you would use the NETWORKDAYS function<br/>
`NETWORKDAYS(DATE(2024, 05, 01), DATE(2024, 05, 31),1)`
<br/> The function returns the value **23**.

## Example 2

Suppose you want to use the system defined start and end date, you can use the NETWORKDAYS function as follows <br/> `NETWORKDAYS (@StartDate, @EndDate, 1)`
<br/>
The calculated column will return the value, based on the start and end date.