Skip to main content
The Count Business Days tool can help you count the number of business days between two dates while accounting for holidays. The Count Business Days tool outputs two anchors. The “Holidays” anchor contains the holidays that were used to calculate the new date - use this to validate the holidays that were used. The “Data” anchor contains the primary data with the new date column.

​
Configuration

If you want to bring your own holidays data, you need to connect your primary data to the D anchor and the dataset containing your holidays to the H anchor. Check out the example to see how.
1

Input Column Name

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

Start date column

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

End date column

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

Method

Select whether you 1) don’t want to account for holidays, 2) want to account for holidays and want to use our built-in holidays, or 3) want to account for holidays and have your own holiday data.
5

Less holidays: Holiday country

If you choose to use our built-in holidays, you can specify the country that you want to use for the holidays.
6

Less holidays: Holiday category (optional)

For some countries there are optional holidays that can be included. For instance, in Denmark, December 24th is technically not a public holiday, but it is a closing day under the Danish Closing Act. Such examples exist and can be included with the holday categories input.
7

Own holidays: Holiday date column

If you choose to use your own holiday data, you need to specify the column in your holiday data (dataset connected to the H anchor) that contains the holiday dates.

​
Example: Counting business days using own, custom holidays

In this example, we’re using our own custom holidays dataset which contains Mon Jan 9th, Tue Jan 10th, Wed Jan 11th and Thu Jan 12th as holidays .
We connect the H anchor to our custom holidays and the primary data to the D anchor. If we look at row 1, we’ll see that we’re counting business days between Jan 1 and Jan 31 2023. There are 21 business days in this period (check here if you’re curious). We have 4 holidays in our custom holidays dataset within this period, so the output is 17 business days between Jan 1 and Jan 31 2023.