Sometimes you need the dates of public holidays like Christmas Eve. As soon as you need them for a lot of countries, you might not want to create the records manually each year by typing them in.
We created now a generic solution that can generate the needed records based on rules tables for each country.
It supports the holidays that depend on the Easter-Sunday-calculation, as well as fixed days (that's easy) plus rules like "4th Thursday in November", which is Thanksgiving in the USA.
For specific cases there are functions like USIndependenceDay(), which is on 4th of July but different when that falls on a weekend.
Also supported is a 1:n-table for holidays that are region specific.
As that is quite tricky for example for Switzerland, it is also possible to just choose the holidays one needs for a specific branch in Switzerland.
In case someone needs that for an application, just contact me via LinkedIn.