MarketplaceStudioActivityCalculate Business Days

Create your first automation in just a few minutes.Try Studio Web

Calculate Business Days

Calculate Business Days

by Kartikay Dhar

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

453

back button
back button
carouselImage0
next button
next button

Summary

Summary

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

Overview

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

Features

Features

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

Additional Information

Additional Information

Dependencies

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

Code Language

Visual Basic

Runtime

Windows (.Net 5.0 or higher)

Publisher

Kartikay Dhar

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.1

Updated

September 6, 2021

Works with

Studio: 19.4 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Resources

Similar Listings