networkdays() Function
This function may not be compatible with all features of Appian. For details, see the Feature Compatibility section below.

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
Open in Github Built: Fri, Aug 12, 2022 (10:01:45 AM)

On This Page

FEEDBACK