Free cookie consent management tool by TermsFeed networkdays() Function
networkdays() Function

Function

networkdays( starting_date, ending_date, holidays )

Returns the number of working days between two specified dates.

Parameters

Keyword Type Description

starting_date

Date

The starting date.

ending_date

Date

The ending date.

holidays

Date

A list of holidays not counted as workdays.

Returns

Integer

Usage considerations

An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}.

Examples

networkdays(date(2011,12,13),date(2011,12,20)) returns 6

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Custom Record Field Expressions Compatible
Process Reports Compatible
Process Events Compatible
Open in Github Built: Fri, Feb 23, 2024 (09:12:49 PM)

networkdays() Function

FEEDBACK