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)

Tip

You can call in the system defined date function start date and end date as @StartDate and @StartDate respectively.

Steps to Use NETWORKDAYS Function

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.

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. 1 or omitted. Consider both Saturday and Sunday as the weekends. 2. Sunday and Monday are considered the weekends. 3. Monday and Tuesday are considered the weekends. 4. Tuesday and Wednesday are considered the weekends. 5. Wednesday and Thursday are considered the weekends. 6. Thursday and Friday are considered the weekends. 7. Friday and Saturday are considered the weekends. 11. Only Sunday is considered the weekend. 12. Only Monday is considered the weekend. 13. Only Tuesday is considered the weekend. 14. Only Wednesday is considered the weekend. 15. Only Thursday is considered the weekend. 16. Only Friday is considered the weekend. 17. Only Saturday is considered the weekend.

Example 1

Assume you have the following dates

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
NETWORKDAYS(DATE(2024, 05, 01), DATE(2024, 05, 31),1)
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
NETWORKDAYS (@StartDate, @EndDate, 1)

The calculated column will return the value, based on the start and end date.