Select nearest holiday from random date from date interface tool

[ShivAlt]

Please help to figure out the below scenario
I have a date interface tool from where I'm selecting the random date and I need to list out the upcoming holiday data and next working day(exclude Saturday & Sunday) 

Holiday Country	Process date	Holiday name
Spain	12/8/2022	xyz
US	14/8/2022	dfg
Chile	15/8/2022	edc
UK	25/12/2022	ddd
Aus	25/12/2022	rrr
Chile	31/8/2022	www

Suppose I picked up Running date from Date interface tool 11/8/2022 then my output will be:

Holiday Country	Process date	Holiday name	Working Date
Spain	12/8/2022	xyz	15/8/2022

Please find the attached AT
Thank you so much...:-)

[Qiu]

@ShivAlt 
Can you see the comments below

1. Can you upload the input Excel file, it was not include in your zip file

2. What would be the time duration to define "upcoming"? The UK holiday 'ddd' is upcoming holiday technically. 😁

[ShivAlt]

@Qiu 
Thanks for the response!!!
I have edited and added the holiday input file.
Upcoming holiday E.g.: Today is 22/8/2022 so if I run the job and there is a holiday for tommrow then it will give me that row from Holiday_List input file.🙂

[Qiu]

@ShivAlt 
I am sorry but I have to ask the logic here.
For your first sample, you pick 2022-08-11, I can understand about the spain, since the next day 2022-08-12 is a holiday, the it follows weekend 2022-08-13 and 2022-08-15 so working day is 2022-08-15.

But for US, the 2022-08-12 is not holiday, so the workday shall be 2022-08-12?

If you say, we have to consider the holiday of Spain, that is why the next working day for US is 2022-08-15, but it contradicts with the case of Chilie again.

[ShivAlt]

@Qiu 

Yes You are absolutely right that was my bad, I have edited my output...Thanks again🙂

[Qiu]

@ShivAlt 
Thank you for the clarification.

I came up with a quite lengthy one, hope you dont mind.
For a certain picked date, it will calculate the next working by considering holiday, weends as non-working days. and the next upcoming holiday.