Holidays and working days
Public holidays of 13 countries for the years 2000 to 2099, with regional days where they apply, and working day calculations that skip weekends and holidays. Typical uses: compute a delivery or payment due date in working days, count the working days of a month.
date holidaysdate holidaysdate is_holidaydate is_holidaydate workdaysdate workdaysdate add_workdaysdate add_workdays
date holidays <country> <year>
Description
The public holidays of a country for a year (2000 to 2099). Result: a JSON array sorted by date of {date, name (English), name_fr, day, observed, id}. id is stable (new_year, easter_monday, ...): use it in code rather than the names
The public holidays of a country for a year (2000 to 2099). Result: a JSON array sorted by date of {date, name (English), name_fr, day, observed, id}. id is stable (new_year, easter_monday, ...): use it in code rather than the names
Parameters
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
year: The year, 2000 to 2099 - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
year: The year, 2000 to 2099 - String - required
admin
date holidays "IT" "2027"
mentdb
[{"date": "2027-01-01", "name": "New Year's Day", "name_fr": "Jour de l'an", "day": "friday", "observed": false, "id": "new_year"}, {"date": "2027-01-06", "name": "Epiphany", "name_fr": "Épiphanie", "day": "wednesday", "observed": false, "id": "epiphany"}, {"date": "2027-03-29", "name": "Easter Monday", "name_fr": "Lundi de Pâques", "day": "monday", "observed": false, "id": "easter_monday"}, {"date": "2027-04-25", "name": "Liberation Day", "name_fr": "Fête de la Libération", "day": "sunday", "observed": false, "id": "liberation_it"}, {"date": "2027-05-01", "name": "Labour Day", "name_fr": "Fête du Travail", "day": "saturday", "observed": false, "id": "labour_day"}, {"date": "2027-06-02", "name": "Republic Day", "name_fr": "Fête de la République", "day": "wednesday", "observed": false, "id": "republic_it"}, {"date": "2027-08-15", "name": "Assumption Day", "name_fr": "Assomption", "day": "sunday", "observed": false, "id": "assumption"}, {"date": "2027-10-04", "name": "Saint Francis of Assisi", "name_fr": "Saint François d'Assise", "day": "monday", "observed": false, "id": "st_francis"}, {"date": "2027-11-01", "name": "All Saints' Day", "name_fr": "Toussaint", "day": "monday", "observed": false, "id": "all_saints"}, {"date": "2027-12-08", "name": "Immaculate Conception", "name_fr": "Immaculée Conception", "day": "wednesday", "observed": false, "id": "immaculate"}, {"date": "2027-12-25", "name": "Christmas Day", "name_fr": "Noël", "day": "saturday", "observed": false, "id": "christmas"}, {"date": "2027-12-26", "name": "Saint Stephen's Day", "name_fr": "Saint-Étienne", "day": "sunday", "observed": false, "id": "st_stephen"}]
US federal holidays in 2027, with the observed days
admin
date holidays "US" "2027"
mentdb
[{"date": "2027-01-01", "name": "New Year's Day", "name_fr": "Jour de l'an", "day": "friday", "observed": false, "id": "new_year"}, {"date": "2027-01-18", "name": "Martin Luther King Jr. Day", "name_fr": "Journée de Martin Luther King", "day": "monday", "observed": false, "id": "mlk"}, {"date": "2027-02-15", "name": "Washington's Birthday", "name_fr": "Anniversaire de Washington", "day": "monday", "observed": false, "id": "washington"}, {"date": "2027-05-31", "name": "Memorial Day", "name_fr": "Memorial Day", "day": "monday", "observed": false, "id": "memorial_day"}, {"date": "2027-06-18", "name": "Juneteenth National Independence Day (observed)", "name_fr": "Juneteenth (reporté)", "day": "friday", "observed": true, "id": "juneteenth"}, {"date": "2027-06-19", "name": "Juneteenth National Independence Day", "name_fr": "Juneteenth", "day": "saturday", "observed": false, "id": "juneteenth"}, {"date": "2027-07-04", "name": "Independence Day", "name_fr": "Fête de l'Indépendance", "day": "sunday", "observed": false, "id": "independence_us"}, {"date": "2027-07-05", "name": "Independence Day (observed)", "name_fr": "Fête de l'Indépendance (reporté)", "day": "monday", "observed": true, "id": "independence_us"}, {"date": "2027-09-06", "name": "Labor Day", "name_fr": "Fête du Travail", "day": "monday", "observed": false, "id": "labor_day_us"}, {"date": "2027-10-11", "name": "Columbus Day", "name_fr": "Columbus Day", "day": "monday", "observed": false, "id": "columbus_day"}, {"date": "2027-11-11", "name": "Veterans Day", "name_fr": "Veterans Day", "day": "thursday", "observed": false, "id": "veterans_day"}, {"date": "2027-11-25", "name": "Thanksgiving Day", "name_fr": "Thanksgiving", "day": "thursday", "observed": false, "id": "thanksgiving_us"}, {"date": "2027-12-24", "name": "Christmas Day (observed)", "name_fr": "Noël (reporté)", "day": "friday", "observed": true, "id": "christmas"}, {"date": "2027-12-25", "name": "Christmas Day", "name_fr": "Noël", "day": "saturday", "observed": false, "id": "christmas"}, {"date": "2027-12-31", "name": "New Year's Day (observed)", "name_fr": "Jour de l'an (reporté)", "day": "friday", "observed": true, "id": "new_year"}]
date holidays <country> <year> <region>
Description
The public holidays of a region of a country for a year. Result: a JSON array sorted by date of {date, name (English), name_fr, day, observed, id}. id is stable (new_year, easter_monday, ...): use it in code rather than the names
The public holidays of a region of a country for a year. Result: a JSON array sorted by date of {date, name (English), name_fr, day, observed, id}. id is stable (new_year, easter_monday, ...): use it in code rather than the names
Parameters
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
year: The year, 2000 to 2099 - String - required
region: FR: alsace_moselle (also alsace, moselle, 57, 67, 68), GP, MQ, GF, RE, YT, BL, MF (also the names and 971 to 976); DE: the code of the Land (BB, BE, BW, BY, HB, HE, HH, MV, NI, NW, RP, SH, SL, SN, ST, TH); CH: the code of the canton (AG ... ZH); GB: ENG (default), WLS, SCT, NIR (also england, wales, scotland, northern_ireland); US and CA: empty or federal; the other countries: empty - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
year: The year, 2000 to 2099 - String - required
region: FR: alsace_moselle (also alsace, moselle, 57, 67, 68), GP, MQ, GF, RE, YT, BL, MF (also the names and 971 to 976); DE: the code of the Land (BB, BE, BW, BY, HB, HE, HH, MV, NI, NW, RP, SH, SL, SN, ST, TH); CH: the code of the canton (AG ... ZH); GB: ENG (default), WLS, SCT, NIR (also england, wales, scotland, northern_ireland); US and CA: empty or federal; the other countries: empty - String - required
admin
date holidays "FR" "2026" "RE"
mentdb
[{"date": "2026-01-01", "name": "New Year's Day", "name_fr": "Jour de l'an", "day": "thursday", "observed": false, "id": "new_year"}, {"date": "2026-04-06", "name": "Easter Monday", "name_fr": "Lundi de Pâques", "day": "monday", "observed": false, "id": "easter_monday"}, {"date": "2026-05-01", "name": "Labour Day", "name_fr": "Fête du Travail", "day": "friday", "observed": false, "id": "labour_day"}, {"date": "2026-05-08", "name": "Victory in Europe Day", "name_fr": "Victoire 1945", "day": "friday", "observed": false, "id": "victory_1945"}, {"date": "2026-05-14", "name": "Ascension Day", "name_fr": "Ascension", "day": "thursday", "observed": false, "id": "ascension"}, {"date": "2026-05-25", "name": "Whit Monday", "name_fr": "Lundi de Pentecôte", "day": "monday", "observed": false, "id": "whit_monday"}, {"date": "2026-07-14", "name": "National Day", "name_fr": "Fête nationale", "day": "tuesday", "observed": false, "id": "national_fr"}, {"date": "2026-08-15", "name": "Assumption Day", "name_fr": "Assomption", "day": "saturday", "observed": false, "id": "assumption"}, {"date": "2026-11-01", "name": "All Saints' Day", "name_fr": "Toussaint", "day": "sunday", "observed": false, "id": "all_saints"}, {"date": "2026-11-11", "name": "Armistice Day", "name_fr": "Armistice 1918", "day": "wednesday", "observed": false, "id": "armistice"}, {"date": "2026-12-20", "name": "Abolition of Slavery", "name_fr": "Abolition de l'esclavage", "day": "sunday", "observed": false, "id": "abolition"}, {"date": "2026-12-25", "name": "Christmas Day", "name_fr": "Noël", "day": "friday", "observed": false, "id": "christmas"}]
Scotland in 2026, with the World Cup bank holiday and the substitute days
admin
date holidays "GB" "2026" "scotland"
mentdb
[{"date": "2026-01-01", "name": "New Year's Day", "name_fr": "Jour de l'an", "day": "thursday", "observed": false, "id": "new_year"}, {"date": "2026-01-02", "name": "New Year Holiday", "name_fr": "Lendemain du jour de l'an", "day": "friday", "observed": false, "id": "jan2"}, {"date": "2026-04-03", "name": "Good Friday", "name_fr": "Vendredi saint", "day": "friday", "observed": false, "id": "good_friday"}, {"date": "2026-05-04", "name": "Early May Bank Holiday", "name_fr": "Jour férié de début mai", "day": "monday", "observed": false, "id": "early_may"}, {"date": "2026-05-25", "name": "Spring Bank Holiday", "name_fr": "Jour férié de printemps", "day": "monday", "observed": false, "id": "spring_bank"}, {"date": "2026-06-15", "name": "Scotland at the FIFA World Cup", "name_fr": "Écosse à la Coupe du monde de la FIFA", "day": "monday", "observed": false, "id": "world_cup_2026"}, {"date": "2026-08-03", "name": "Summer Bank Holiday", "name_fr": "Jour férié d'été", "day": "monday", "observed": false, "id": "summer_bank"}, {"date": "2026-11-30", "name": "Saint Andrew's Day", "name_fr": "Saint-André", "day": "monday", "observed": false, "id": "st_andrew"}, {"date": "2026-12-25", "name": "Christmas Day", "name_fr": "Noël", "day": "friday", "observed": false, "id": "christmas"}, {"date": "2026-12-26", "name": "Boxing Day", "name_fr": "Lendemain de Noël", "day": "saturday", "observed": false, "id": "boxing_day"}, {"date": "2026-12-28", "name": "Boxing Day (observed)", "name_fr": "Lendemain de Noël (reporté)", "day": "monday", "observed": true, "id": "boxing_day"}]
Geneva: Jeûne genevois and 31 December
admin
date holidays "CH" "2026" "GE"
mentdb
[{"date": "2026-01-01", "name": "New Year's Day", "name_fr": "Jour de l'an", "day": "thursday", "observed": false, "id": "new_year"}, {"date": "2026-04-03", "name": "Good Friday", "name_fr": "Vendredi saint", "day": "friday", "observed": false, "id": "good_friday"}, {"date": "2026-04-06", "name": "Easter Monday", "name_fr": "Lundi de Pâques", "day": "monday", "observed": false, "id": "easter_monday"}, {"date": "2026-05-14", "name": "Ascension Day", "name_fr": "Ascension", "day": "thursday", "observed": false, "id": "ascension"}, {"date": "2026-05-25", "name": "Whit Monday", "name_fr": "Lundi de Pentecôte", "day": "monday", "observed": false, "id": "whit_monday"}, {"date": "2026-08-01", "name": "Swiss National Day", "name_fr": "Fête nationale suisse", "day": "saturday", "observed": false, "id": "national_ch"}, {"date": "2026-09-10", "name": "Genevan Fast", "name_fr": "Jeûne genevois", "day": "thursday", "observed": false, "id": "genevan_fast"}, {"date": "2026-12-25", "name": "Christmas Day", "name_fr": "Noël", "day": "friday", "observed": false, "id": "christmas"}, {"date": "2026-12-31", "name": "Restoration of the Republic", "name_fr": "Restauration de la République", "day": "thursday", "observed": false, "id": "restoration_ge"}]
Used in use cases (1 recipe)
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
date is_holiday <date> <country>
Description
1 when the date is a public holiday (or an observed day) of the country, else 0. A date with a time (yyyy-MM-dd HH:mm:ss, or T, a fraction and a zone) is read by its date; any other text after the date is an error
1 when the date is a public holiday (or an observed day) of the country, else 0. A date with a time (yyyy-MM-dd HH:mm:ss, or T, a fraction and a zone) is read by its date; any other text after the date is an error
Parameters
date: yyyy-MM-dd - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
date: yyyy-MM-dd - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
admin
date is_holiday "2026-07-03" "US"
mentdb
1
A normal day
admin
date is_holiday "2026-11-10" "FR"
mentdb
0
date is_holiday <date> <country> <region>
Description
Same for a region
Same for a region
Parameters
date: yyyy-MM-dd - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
region: FR: alsace_moselle (also alsace, moselle, 57, 67, 68), GP, MQ, GF, RE, YT, BL, MF (also the names and 971 to 976); DE: the code of the Land (BB, BE, BW, BY, HB, HE, HH, MV, NI, NW, RP, SH, SL, SN, ST, TH); CH: the code of the canton (AG ... ZH); GB: ENG (default), WLS, SCT, NIR (also england, wales, scotland, northern_ireland); US and CA: empty or federal; the other countries: empty - String - required
date: yyyy-MM-dd - String - required
country: BE, CA, CH, DE, ES, FR, GB (or UK), IE, IT, LU, NL, PT or US - String - required
region: FR: alsace_moselle (also alsace, moselle, 57, 67, 68), GP, MQ, GF, RE, YT, BL, MF (also the names and 971 to 976); DE: the code of the Land (BB, BE, BW, BY, HB, HE, HH, MV, NI, NW, RP, SH, SL, SN, ST, TH); CH: the code of the canton (AG ... ZH); GB: ENG (default), WLS, SCT, NIR (also england, wales, scotland, northern_ireland); US and CA: empty or federal; the other countries: empty - String - required
admin
date is_holiday "2026-11-18" "DE" "SN"
mentdb
1
Good Friday in Alsace-Moselle
admin
date is_holiday "2026-04-03" "FR" "alsace"
mentdb
1
Used in use cases (1 recipe)
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
date workdays <start> <end> <country>
Description
The working days from start (included) to end (excluded): not Saturday, not Sunday, not a public holiday; negative when end is before start, as date business_days_fr. country none: weekends only
The working days from start (included) to end (excluded): not Saturday, not Sunday, not a public holiday; negative when end is before start, as date business_days_fr. country none: weekends only
Parameters
start: yyyy-MM-dd - String - required
end: yyyy-MM-dd - String - required
country: A country as in date holidays, or none - String - required
start: yyyy-MM-dd - String - required
end: yyyy-MM-dd - String - required
country: A country as in date holidays, or none - String - required
admin
date workdays "2026-01-01" "2027-01-01" "FR"
mentdb
252
December 2026 in England
admin
date workdays "2026-12-01" "2027-01-01" "GB"
mentdb
21
date workdays <start> <end> <country> <json_params>
Description
The working days with options: region (see date holidays), weekend (["sat", "sun"]: a JSON array of day names, monday ... sunday or mon ... sun; [] for none), extra_holidays (a JSON array of dates yyyy-MM-dd added as days off: company closing, local holiday, 10000 at most), observed (true: the observed days of US, GB and CA are days off too)
The working days with options: region (see date holidays), weekend (["sat", "sun"]: a JSON array of day names, monday ... sunday or mon ... sun; [] for none), extra_holidays (a JSON array of dates yyyy-MM-dd added as days off: company closing, local holiday, 10000 at most), observed (true: the observed days of US, GB and CA are days off too)
Parameters
start: yyyy-MM-dd - String - required
end: yyyy-MM-dd - String - required
country: A country as in date holidays, or none - String - required
json_params: The options, as a JSON object - String - required
start: yyyy-MM-dd - String - required
end: yyyy-MM-dd - String - required
country: A country as in date holidays, or none - String - required
json_params: The options, as a JSON object - String - required
admin
date workdays "2026-12-01" "2027-01-01" "FR" "{\"region\": \"RE\", \"extra_holidays\": [\"2026-12-24\", \"2026-12-31\"]}"
mentdb
20
A week of Sunday to Thursday, without holidays
admin
date workdays "2026-11-01" "2026-12-01" "none" "{\"weekend\": [\"fri\", \"sat\"]}"
mentdb
22
Used in use cases (1 recipe)
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
date add_workdays <date> <n> <country>
Description
The date n working days after (n > 0) or before (n < 0) a date, n between -36500 and 36500; n = 0 gives the date itself
The date n working days after (n > 0) or before (n < 0) a date, n between -36500 and 36500; n = 0 gives the date itself
Parameters
date: yyyy-MM-dd - String - required
n: The number of working days - String - required
country: A country as in date holidays, or none - String - required
date: yyyy-MM-dd - String - required
n: The number of working days - String - required
country: A country as in date holidays, or none - String - required
admin
date add_workdays "2026-12-23" "3" "FR"
mentdb
2026-12-29
5 working days before 7 January in Germany (national days only)
admin
date add_workdays "2026-01-07" "-5" "DE"
mentdb
2025-12-30
date add_workdays <date> <n> <country> <json_params>
Description
Add working days with options: region (see date holidays), weekend (["sat", "sun"]: a JSON array of day names, monday ... sunday or mon ... sun; [] for none), extra_holidays (a JSON array of dates yyyy-MM-dd added as days off: company closing, local holiday, 10000 at most), observed (true: the observed days of US, GB and CA are days off too)
Add working days with options: region (see date holidays), weekend (["sat", "sun"]: a JSON array of day names, monday ... sunday or mon ... sun; [] for none), extra_holidays (a JSON array of dates yyyy-MM-dd added as days off: company closing, local holiday, 10000 at most), observed (true: the observed days of US, GB and CA are days off too)
Parameters
date: yyyy-MM-dd - String - required
n: The number of working days - String - required
country: A country as in date holidays, or none - String - required
json_params: The options, as a JSON object - String - required
date: yyyy-MM-dd - String - required
n: The number of working days - String - required
country: A country as in date holidays, or none - String - required
json_params: The options, as a JSON object - String - required
admin
date add_workdays "2026-01-07" "-5" "DE" "{\"region\": \"BY\"}"
mentdb
2025-12-29
Payment due in 30 working days in Belgium
admin
date add_workdays "2026-11-10" "30" "BE" "{\"extra_holidays\": [\"2026-12-24\"]}"
mentdb
2026-12-23
Used in use cases (1 recipe)
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
Accountant & manager › Compute due dates and delays in working days, with the holidays of La Réunion and of Bavaria
