Calculate Business Days
by Kartikay Dhar
0
339
Calculate Business Days
by Kartikay Dhar
0
Custom Activity
339
Summary
Summary
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:
- in_From_Date: The From date in DateTime Format.
- in_To_Date: The To date in DateTime Format.
- in_Country_Code: Keep as “US” for US Federal Holidays. If you want to pass custom holidays, leave as Blank.
- in_Year: The Year for which you are running the Activity.
- out_int_Business_Days: Output in Integers for Number of Days.
- optional_in_list_holidays: If you want to give your own holiday list, please provide in List<DateTime> Format.
Features
Features
Convenient way to calculate business days while excluding weekends and holidays.
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
1.0.1Updated
06 Sep 2021Certification
Silver Certified
Tags
Businesss Days
TwoDates
Federal Days
US Business Days
Date Difference
Support
UiPath Community Support
Resources
Similar Listings
English
English
日本語