The Count Business Days tool can help you count the number of days between two dates while accounting for holidays and weekends. You can use the Date Math tool if you’re just looking to add days while accounting for weekends.

You need to bring your own holiday data. You can typically find Excel or .csv files online.

​
Configuration

The Count Business Days tool consists of four required input.

You need to connect your primary data to the D anchor and the dataset containing your holidays to the H anchor. Check out the examples for a reference.

1

Input Column Name

The Count Business Days tool will create a new column. Use this input to name it.

2

Select Start Date Column

Select the column in your primary data containing the start date from which to begin counting.

The calculation to Count Business Days starts on / includes the date you provide as the start date

This column must be formatted as a date/datetime. Use the Change Columns tool to change column formats.

3

Select End Date Column

Select the column in your primary data containing the end date at which to end counting.

This column must be formatted as a date/datetime. Use the Change Columns tool to change column formats.

4

Select Holiday Column

Select the column in your holiday data containing the holiday dates.

This column must be formatted as a date/datetime. Use the Change Columns tool to change column formats.

​
When To Use

Simple - use the Count Business Days when you want to count the number of days between two dates while accounting for weekends and holidays.

​
Examples