DatePop’s public holidays come from the open-source date-holidays project. A trimmed copy of its data is bundled with the add-in, so DatePop never asks a holiday website or service anything.
The data #
- Source: date-holidays version 3.37.0, by commenthol and contributors.
- License of the data: Creative Commons Attribution-ShareAlike 3.0 (CC BY-SA 3.0). The project compiled it from Wikipedia articles and other public sources, which are also CC BY-SA 3.0.
- License of the code: ISC. The code is used only when DatePop is built, to extract the data; it is not part of the add-in.
- Attribution: the pane’s About page names the data and links here, and the full attribution is in the third-party notices that ship with DatePop.
What is included #
- Countries and territories (207): every country and territory the library lists, from Andorra and Argentina to the United States and Vietnam, including territories such as Puerto Rico and Hong Kong. The country list in Settings and in the calendar options shows them all.
- Regions (364): for many countries you can choose a region, such as a US state, a Canadian province, a German state, a Swiss canton, a Spanish community or an Australian state. Whole country gives the national list.
- Public holidays only. Observances, school holidays, bank holidays that are not public holidays and company days off are not included.
- Years 2020 to 2040. Outside that range DatePop shows no holidays.
- Names: each holiday has the name in the country’s default language and in English.
What DatePop does with the data #
The dates and names are the library’s, unchanged. The files are only re-encoded in a compact format so they load quickly, which changes no date and no name. One change happens on screen: where a holiday name contains an em dash or en dash, DatePop shows it as a middle dot or a hyphen. The stored data is not touched.
Because of the ShareAlike license, these data files stay available under CC BY-SA 3.0 and anyone may reuse them under the same license with the attribution above.
How accurate is it? #
The data is maintained by a community and is usually right, but laws change and some holidays are announced late or only once, such as an extra day off for a special occasion. If a printed calendar must be exact, check the holidays that matter against an official source of your country or employer before you print. If you find an error, the project accepts corrections on its GitHub page; DatePop picks up new data with a later release.
Where do I use holidays? #
Choose a Holiday country in Settings (Pro). Holidays then show as dots in the picker, as shaded days with names in the calendars, and in the rules of fill series and date fields. The holiday file is loaded from the same address as the pane; the request carries no workbook data. Once loaded it stays in memory while DatePop runs.