Get Holidays Dynamically

[Hsandness]

Wanted to post because I couldn't find a solution to my problem. In a workflow I have, I need to exclude dates that land on certain holidays. A static file works fine for holidays like New Years or Christmas since those dates don't change. However, I also need to exclude Memorial, Labor, and Thanksgiving Day which can all fall on different days depending on the year.

Attached is a workflow I created that gets all three of these dates dynamically. I used a combination of formula, summarize, generate rows and filter tools to get the desired dates.

Memorial Day is the last Friday in the month of May. 

Labor Day is the first Monday in the month of September.

Thanksgiving Day is the third Thursday in November.

Any suggestions for improvement are welcome and hopefully this helps one of you!

[abacon]

@Hsandness That's really helpful! Another option to look into is an API call to get holiday information and pass that into your workflow.

There are options online for which one to use to pull the dates into your workflow.

Bacon

[binuacs · Accepted solution]

@Hsandness Attaching the API version

[Hsandness]

@binuacs This is great, thank you for providing it.