NETWORKDAYS

Syntax

NETWORKDAYS(<date>;<date>;[holidays])

Description

Using the ‘NETWORKDAYS’ function returns the number of whole working days between a start date and an end date. Working days exclude weekends and any dates that are identified as holidays.

‘NETWORKDAYS’:

• returns null in case a date is missing

• does not include weekend days

• displays a negative amount if the end date is before the start date

• subtracts all holidays when they are marked with the holiday variable in a single column

• does not subtract holidays when they are on a weekend

Example Without Holidays

Given the following date:

• August 23rd in 2021 to August 24th in 2021 = 2 days, thereof 0 days weekend, thereof 0 days holidays

Formula applied:

Example With Holidays

Given the following date:

• August 23rd in 2021 to August 29th in 2021 = 7 days, thereof 2 days weekend, thereof 2 days holidays on Aug, 24th and Aug, 29th

Formula applied: