Dynamic Calendar Template for Excel is now available for download:
dailyexcel.net calendar currently supports 10 scenarios/countries for years from 2024 to 2028:
No single workday rule, as well as three additional from-to periods, are available for collective vacation planning.
Hours worked in a week, as well as holiday and vacation hours, are automatically calculated in order to support planning of business days.
For supported scenarios, holidays are automatically downloaded via connection to the dailyexcel.net site:
Day, month and holiday names are automatically updated depending on the supported locale:
Holidays falling on weekends are listed twice, once as a holiday, and the second time marked with (Observed) to denote the days off because a holiday fell on a weekend:
Given array functions used, you will need Excel 2021 or later, or Microsoft 365 in order to use this calendar.
To se more technical details on how this calendar functions, see this article on how to Generate lists of working and non-working days.
You can read up on how applied formatting works in the article Custom Date Formats in Excel and the article on the TEXT function.
Other functions used in this calendar are listed below, under Tags.
Merry Christmas and Happy New Year!