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 helpful to me
What to do if it falls under holiday list or sat or sun?
then that also should skip
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 date, validate if the date is either a saturday or sunday, or if it is present in the holiday datatable. If so, skip it, if not, add it to your workingday collection.
As soon as you have your 10 working days, exit the loop.
Then, check if your input date is in your working day collection and draw your conclusions.
This will work in both of your recent forum posts.
@Nikhil_Katta Please mark this as a solution as well because same code solves both of your problems. 
Regards
Pratik