=HOLIDAYS("FR",2026)
=HOLIDAYS("FR",2026)Returns the known date/name table, beginning 2026-01-01 · New Year's Day.
Country guide · FR
France holidays and business days
Use "FR" for the France country-level calendar. The following coverage describes the pinned release 2026-09-15-holidays-0.104-t0-repair-5.
Weekend rule
Saturday–Sunday, using the Monday-to-Sunday mask 0000011 throughout 2000–2035 in this release. The optional weekend argument overrides the default; extra closures and public holidays still take precedence.
Coverage is statutory weekend only: this code has no source working-weekend data. We do not infer make-up working days or employer-specific schedules.
Subdivision support
The source provides selected regional and overseas calendars, including Moselle (57), Alsace (6AE), French Guiana (973) and Réunion (974), on Pro. This is the source’s directory, not every French administrative region.
14 subdivision entries. =SUBDIVISIONS("FR") lists the supported suffixes and names on either plan. Using a regional calendar requires Pro.
View all 14 subdivision codes
| Suffix | Name |
|---|---|
57 | Moselle |
6AE | Alsace |
971 | Guadeloupe |
972 | Martinique |
973 | French Guiana |
974 | Réunion |
976 | Mayotte |
BL | Saint-Barthélemy |
MF | Saint-Martin |
NC | Nouvelle-Calédonie |
PF | Polynésie Française |
PM | Saint-Pierre-et-Miquelon |
TF | Terres australes françaises |
WF | Wallis-et-Futuna |
Complete years and estimated dates
The national calendar has complete years 2000–2035 in the pinned audit. Each subdivision has its own completeness flags; do not infer regional completeness from this national range.
First estimated year: none labelled in 2000–2035 for this national calendar or its listed subdivisions. No label is not proof of confirmation; completeness is checked independently.
Estimated dates can move by a day when authorities confirm them. Holiday names preserve the source’s " (estimated)" suffix where supplied; some source names suppress that label.
Worked examples
=ISHOLIDAY("2026-01-01","FR")
=ISHOLIDAY("2026-01-01","FR")Returns TRUE for the first listed national public holiday in 2026.
Free and Pro
Free: every formula for the current calendar year and the next one, in the spreadsheet’s timezone; country-level only, no subdivisions and no custom extra ranges. In 2026, that window is 2026–2027.
Pro: $29/year or $4/month; holiday lists: 2000–2035, subject to source coverage; business-day formulas: years with published calendars. Includes subdivisions, custom extra ranges, and priority data corrections. Compare plans and owner-based access.
Calendar coverage and estimated dates
Estimated dates can move by a day when authorities confirm them. HOLIDAYS and HOLIDAYNAME preserve the source’s exact " (estimated)" suffix where supplied. An absent label does not prove that a date is confirmed.
For codes without working-weekend data, coverage is statutory weekend only: public holidays and the configured weekend rule, with no inferred make-up working days. Business-day formulas require a complete calendar for every year touched; Pro does not unlock unpublished calendars. Read the data coverage guide.