445b5db1-be56-41d6-82ac-84902d8a8ba0.jpg

UiPath Solution Architect

d3943594-0ef1-40a2-b7d4-4d5f460dfb12.nupkg

One of the most asked about feature in business is to calculate the business days between dates to validate if there is any SLA that was missed.

  

There is an easy way to do it currently, especially with a Holiday Calendar.

  

To resolve this, I created this activity that can:

  

1\. Use the Federal Holiday List for US (pulled dynamically for the year required.)

2\. Send a custom list of Dates to be excluded.

  

  

**Arguments**:

1.  **in\_From\_Date**: The From date in DateTime Format.
2.  **in\_To\_Date**: The To date in DateTime Format.
3.  **in\_Country\_Code**: Keep as “US” for US Federal Holidays. If you want to pass custom holidays, leave as Blank.
4.  **in\_Year**: The Year for which you are running the Activity.
5.  **out\_int\_Business\_Days**: Output in Integers for Number of Days.
6.  **optional\_in\_list\_holidays**: If you want to give your own holiday list, please provide in List Format.

Calculate the business days between two dates while excluding weekends and holidays.

4490b73b-0a63-40fa-b12c-8b167439db0e.jpg

Version	Release Date	Download Link
1.0.1	September 15, 2021
1. Fixed an issue where Bot was failing if no Holidays were provided.
1.0.0	August 19, 2021
1. Capability to calculate business days between two dates while excluding weekends and holidays. 2. Ability to automatically add Federal Holidays for US. (Using API Call in the backend) 3. The API being utilised is Open Source and does not require any Licence. 4. There is no limit on the number of calls that can be made. 5. You can pull the holiday list for any year dynamically. Upcoming changes: 1. Support for Canada, India, UK and more (based on request)

Calculate Business Days