hi team ,
i have a scenario like to calculate -10 business days from the todays date
US_Holiday_list.xlsx (8.4 KB)
Can some create a workflow for this logic
'attached file is the business holidays list
input date = “03/05/2024”
Output date =“02/10/2024”
becoz we have to skip sat and sunday
If Input Date: 03/05/2024 after subtracting 10 business days it should be 02/20/2024. Please check and specify.
Regards
Take your input date, and keep substracting 1 day in a loop.
Check if the created day is either a holiday in your excelsheet, or a saterday or sunday. If not, add 1 to an integer keeping trck of the businessday count. As soon as it hits 10, exit your loop and you have your output date.
yes u are correct … sorry for it
can you please create one workflow
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.
Please mark it as a solution if it solved your problem.
Regards
Pratik
no studio access from here at the moment, sorry.
thank you so much… this is working fine
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.