Date - Business Days and Holidays - Germany

Extract the public holidays for each federal geman state ("Bundesland") - also extract the vacations ("Schulferien") for a given year.You can adapt this for other countries as well. Let ChatGPT give you a list of holidays and vacations.You will have a list of the dates and you can then match which day is a holiday or when schools will be closed. You can count how many states are on holiday. If it is 16 it is a national holiday.You might have to deal with regional special holiday like the 8th of August in Augsburg "Hohes Friedensfest" or carnival ("Rosenmontag").--------Also: Calculate the number of working days between any give dates. Excluding Saturdays and Sundays and also a given list of dates--------Also: Check how many Bundesländer's schools will be closed on any given day - for ML you could give weights by the population or use this if you have a location based task--------Also: Mark gap days (Brückentage) that are between a public holiday and a weekend for example

URL: R solution with bizdays https://forum.knime.com/t/working-days-network-days-between-two-dates/14682/4?u=mlauber71
URL: A solution with R using "officeholidays" https://forum.knime.com/t/dividing-and-splitting-rows/11381/5?u=mlauber71
URL: Python Conda: Generate and work with holidays in Python https://anaconda.org/conda-forge/holidays
URL: Medium: Business Days and Holidays in KNIME https://medium.com/p/1a161782b074
URL: Forum: first working day in the next month https://forum.knime.com/t/filter-by-less-than-or-equal-first-business-day-of-the-following-month/17467/12?u=mlauber71
URL: AP-14411 - Ticket to handle Business Days in KNIME https://forum.knime.com/search?q=AP-14411

Extract the public holidays for each federal geman state ("Bundesland") - also extract the vacations ("Schulferien") for a given year.

Calculate the number of working days between any give dates. Excluding Saturdays and Sundays and also a given list of extra dates ("Feiertage")

Check how many Bundesländer's schools will be closed on any given day - for ML you could give weights by the population or use this if you have a location based task

What percentage of the population will be on vacation on any given date in Germany

Try to extract lists of school vacations per german state from a website / API

Determine Gap Days ("Brückentage" in German) - days that are between a holiday and a weekend. Like when Thursday is a holiday and Friday would be a gap day

Blog: Business Days and Holidays in KNIME

KNIME Snippets (5) — Python Overview

Extract a list of holidays for Germany and German states from python package 'holidays' for a given year