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.