Add Business Days
Add a number of days to a date while accounting for holidays
The Add Business Days tool is used to add a number of days 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 Add Business Days tool consists of four required input and one optional in the Additional Settings.
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.
Input Column Name
The Add Business Days tool will create a new column. Use this input to name it.
Select Start Date Column
Select the column in your primary data containing the date to which you want to add a number of days.
The calculation to add 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.
Select Duration Column
Select the column in your primary data that contains the number of business days that you would like to add to your date column from Step #2.
This column must be formatted as an integer/whole number. Use the Change Columns tool to change column formats.
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.
Addtional Settings: Multiple Countries
If you want to account for multiple different countries, you can use the additional settings to specify which column in each dataset determines the country. Note that these must be formatted identical, i.e. “United States of America” and “USA” won’t work.
When To Use
This is relatively simple. Use the Add Business Days when you want to add a number of days to a date accounting for weekends and holidays.