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

Date Time

Accepted answers

ScottLewis

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.

Holiday Dates.yxmd

All comments

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

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

Holiday Dates.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335