Select nearest holiday from random date from date interface tool

Question

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 CountryProcess dateHoliday nameSpain12/8/2022xyzUS14/8/2022dfgChile15/8/2022edcUK25/12/2022dddAus25/12/2022rrrChile31/8/2022www

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

Holiday CountryProcess dateHoliday nameWorking Date

Spain12/8/2022xyz15/8/2022

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

Alteryx.zip

Qiu · Answer

@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.

Holiday_test-r1.yxzp

ShivAlt · Answer

@Qiu

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

Qiu · Answer

@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.