COB date + Holiday Date

[AshishAgarwal]

Hi Team,

I want to get dates for COB  + Holiday dates.

I can provide input file with list of Holiday dates.

So I want Alteryx to identify COB date and if any previous Holiday date.

For example:

Holiday date is

19th Aug 2025

18th Aug 2025

10th Aug 2025

If COB 20th Aug

Then I should get 3 dates 

20th Aug 2025

19th Aug 2025

18th Aug 2025

If COB is 21st Aug

Then I should get 3 dates 

21st Aug 2025

I dont want to use Python in Alteryx.

Hence is it possible to derive such behavior using different tools?

Regards,

Ashish

[Gaurav_Dhama_]

can you explain the case of 21st Aug, shouldn't you get 21 and 19th Aug as two dates as 19 was a holiday and it is within 3 days?

[ScottLewis · Accepted solution]

Attached solves the problem, there are likely more elegant solutions.

Solution takes a COB data as input, generates the 30 days prior, checks which of them are holidays, flags all holidays and the COB as include and then produces the list of includes until the first exclude by way of multi-row formula.

[AshishAgarwal]

Hi Lewis,

Thank you so much. I am now getting desired result.

However I missed to inform that I need to skip weekends and hence I just input one tool to exclude weekends.

[AshishAgarwal]

Hi All,

I still faced issue on other holiday dates.

I have tried summarizing an example and require your help.

Is it possible to get desired result?

Sceanrio	Holiday	Result
1	Monday	Friday + Monday
2	Monday + Tuesday	Friday + Monday + Tuesday
3	Friday	Thursday + Friday
4	Thursday + Friday	Wednesday + Thursday + Friday
5	Monday + Tuesday + Wednesday	Friday + Monday + Tuesday + Wednesday
6	Wednesday + Thursday + Friday	Tuesday + Wednesday + Thursday + Friday
7	Tuesday	Monday + Tuesday
8	Wednesday	Tuesday + Wednesday
9	Friday + Monday	Thursday + Friday + Monday
10	Sunday	Friday
11	Saturday	Friday
12	Monday & Wednesday	Tuesday only
13	Friday & Tuesday	Monday only