Get business days between dates transform action

Use case

You would like to get the count of business days between dates.

Overview

A photo of the text header in the transform menu of the workflow builder for get business days between dates

Get the number of business days between two dates.

Parameters

Parameter
Description
Required

Start Date

The start date; This day is inclusive in the returned count.

End Date

The end date; This day is exclusive in the returned count.

Holidays

A list of holidays

Country

Country Specific Holidays to remove from the set.

It is important to note that the end date is exclusive in the returned count, only start date is inclusive in the count.

Usage

Example 1: 07/01/2025 through 07/07/2025 excluding US Holidays

Inputs:

Start Date: 07/01/2025

End Date: 07/07/2025

Holidays:

Country: United States of America

Example 2: 07/01/2025 through 07/07/2025 not excluding US Holidays

Inputs:

Start Date: 07/01/2025

End Date: 07/07/2025

Holidays:

Country:

Results output

Result of Example 1:

3

Result of Example 2:

4

Last updated

Was this helpful?