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
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible
Process Reports Compatible
Process Events Compatible
Open in Github Built: Thu, Mar 28, 2024 (10:34:21 PM)

networkdays() Function

FEEDBACK