Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dynamic Way to Identify Changing US Holiday Dates

dmpope
8 - Asteroid

Hi everyone, 

 

I have a workflow where I have to identify holidays in the US to exclude those dates from our data. Some of the holidays that I need to identify are "3rd Monday in January" or "2nd Monday in October" so they don't have consistent dates each year. I want to use formulas to identify these so that the user doesn't have to download a calendar or look at a calendar to identify the holiday, trying to make this workflow as seamless as possible for them. 

 

I've attached what I have so far, but I feel like I may be overcomplicating it or there's something I'm not thinking of when attempting to set up the data for the multi-row formula tool. Could someone please take a look to see if there is a solution?

 

Thank you!

1 REPLY 1
ChrisTX
16 - Nebula
16 - Nebula

This is how I would do it:

 

Screenshot 2024-09-26 100305.png

 

Chris

Labels
Top Solution Authors