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!
