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

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
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

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
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
Often used with

    date add_workdays  ·  date is_holiday  ·  date workdays

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

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
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

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
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
Often used with

    date add_workdays  ·  date holidays  ·  date workdays

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

Parameters

    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)

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
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
Often used with

    date add_workdays  ·  date holidays  ·  date is_holiday

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

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
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)

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
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
Often used with

    date holidays  ·  date is_holiday  ·  date workdays