> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Add Business Days

> Add business days while accounting for holidays

The Add Business Days tool is used to add a number of business days while accounting for holidays. You can use the [Date Math](/tools/new-columns/date-math) tool if you're just looking to add days.

The Add 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.

<Frame>
  <img src="https://mintcdn.com/less-51/7hAaZrB-cL9KB8SD/images/tools/add-business-days/Anchors.gif?s=afa8035ea3e2981edf75334f362c19c8" width="2000" height="1256" data-path="images/tools/add-business-days/Anchors.gif" />
</Frame>

### 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 examples to see how.

<Steps>
  <Step title="Column name">
    The Add Business Days tool will create a new column. Use this input to name it.
  </Step>

  <Step title="Start date column">
    Select the column in your primary data containing the date to which you want to add a number of days.
  </Step>

  <Step title="Business days 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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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.
  </Step>
</Steps>

### Example: Accounting for holidays

In this example, we want to add the integer value of business days in our *simple\_int* column to our *datetime\_col* column. We want to account for holidays in Spain and use our built-in holidays.

<Frame>
  <img src="https://mintcdn.com/less-51/7hAaZrB-cL9KB8SD/images/tools/add-business-days/Spain.png?fit=max&auto=format&n=7hAaZrB-cL9KB8SD&q=85&s=cc1e1f69baaa37e77d074d3b5bbc00dc" width="2194" height="1556" data-path="images/tools/add-business-days/Spain.png" />
</Frame>

Notice that the *H* anchor is empty. This means that we want to use our built-in holidays. Secondly, look at row 5. The start date is Jan 5th 2023 (a Thursday) and we want to add 5 business days (the value in the *simple\_int* column). The output date is Jan 13th 2023. Here's why.

<Frame>
  <img src="https://mintcdn.com/less-51/7hAaZrB-cL9KB8SD/images/tools/add-business-days/Explanation.png?fit=max&auto=format&n=7hAaZrB-cL9KB8SD&q=85&s=c21be9061696f6a4191bafc8168f8f00" width="778" height="612" data-path="images/tools/add-business-days/Explanation.png" />
</Frame>

Jan 6th is skipped because it Epiphany in Spain. The weekend is also skipped whereby our 5-day count begins on Monday, Jan 9th and ends on Friday, Jan 13th which becomes our output date.

### Example: Accounting for holidays and using your own holiday data

You can also bring your own custom holiday data. That might be relevant if your company has its own holiday calendar. In the example below, we have connected the *H* anchor to a custom holiday dataset.

<Frame>
  <img src="https://mintcdn.com/less-51/7hAaZrB-cL9KB8SD/images/tools/add-business-days/Custom.png?fit=max&auto=format&n=7hAaZrB-cL9KB8SD&q=85&s=134c0cd9b62dae8702cadd88207ae598" width="2194" height="1556" data-path="images/tools/add-business-days/Custom.png" />
</Frame>

Our custom holidays for the above example is Jan 9th, 10th and 11th whereby row 5's output date is Jan 17th.
