Hey all,
I created a macro I got a lot of use out in my previous roles. It takes in a single field of dates, finds the first and last date in that set, and returns 4 outputs for the date range:
- H – A list of all holidays, their observed dates, their official name at the Fed, and a colloquial name.
- W – A list of all weekends only
- C – A combined list of holidays and weekends
- R – A list of all reporting days
It also knows when each holiday was first implemented (Juneteenth won't show up before 2021), so you can use it to calculate US holidays all the way back to the founding of America!
You could easily adjust the inputs to ask from dates from a picker interface or split the start and end dates to be separate inputs, if that is something you need.
