i have a scenario … where i have to check the input date falls under 10 last business days which includes US holiday list and also Saturday and Sunday … the date should not falls under these holiday list and sat and Sunday US_Holiday_list.xlsx (8.4 KB) Can u please create one workflow it will help…

What to do if it falls under holiday list or sat or sun?

Create a list or single column datatable to contain the working days. Read the holiday sheet in another datatable using standard excel activities. Create a do-while loop that populates the first collection with non working days, counting backwards from ‘today’ by one day each. Before adding the d…

[image] Calculate -10 business days from todays date Studio Get_Valid_WorkingDay.xaml (15.4 KB) Use in_dt_ListOfHolidays to pass in the holidays data table which you will get after reading your excel file. The out argument date will contain the output date you want. Plea…

@Nikhil_Katta Please mark this as a solution as well because same code solves both of your problems. :slight_smile: Regards Pratik

Business days calculation for date

Help Studio

pratik.santani (Pratik Dilipkumar Santani) March 5, 2024, 1:02pm 5

This will work in both of your recent forum posts.

Topic		Replies	Views
Calculate -10 business days from todays date Studio studio , question , workflow_diff	9	547	March 5, 2024
Can anyone create a business working days workflow Studio studio , question , workflow_diff	14	678	June 26, 2023
Based on system date or today date find the business day number Help	5	3518	January 19, 2021
Determine business day in the past Activities uiautomation , activities , question	2	86	April 26, 2025
Calculate 15th working day of the month(does not include Saturdays and Sundays) Help datatable , excel , orchestrator , string , question	4	1338	July 31, 2020

Business days calculation for date

Related topics