MarketplaceListingsCustom ActivityCalculate Business Days

Calculate Business Days

Bronze Certified

Custom Activity

0 reviews

42

Calculate Business Days

Bronze Certified

Custom Activity

0 reviews

42


Summary

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

carouselImage0

Overview

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<DateTime> Format.

Benefits

Convenient way to calculate business days while excluding weekends and holidays.

Published: 19 Aug 2021 | Updated: 12 Jul 2021

Kartikay Dhar
UiPath Solution Architect

License

By clicking download you agree to the following license.


Code Language

Visual Basic


Runtime

.NET Core


Tags

Businesss Days
TwoDates
Federal Days
US Business Days
Date Difference

Compatibility

Studio: 2019.4+


Dependencies

UiPath.WebAPI.Activities UiPath.UIAutomation.Activities UiPath.Excel.Activities


Documentation


Similar Listings