Public Holidays in France

I'm sure I've already done this, perhaps in a spreadsheet (in a format no longer easily read, perhaps), but I haven't found it.

The basic idea is to compute the possibilities for the number of holidays falling on Monday through Friday in the course of a year. Holidays falling on Saturday are also of interest, but more because they are inconvenient for those with Monday-to-Friday occupations who count on getting their errands done on Saturday. Holidays falling on Sundays are wasted. Monday is especially nice, and Tuesday is even better if one has a floating day off to make the “bridge”.

The Inputs

Event Timing Weekday Origin Scope Day number
(non-leap years)
Day mod 7
New Year's Day January 1 mobile secular international 1 1 (1)
Good Friday Friday religious Alsace-Moselle only
Easter Monday Monday religious national
Labor Day May 1 mobile secular international 121 2 (3)
Victory 1945 May 8 mobile secular national 128 2 (3)
Ascension Thursday religious international
Pentecost Monday Monday religious national
Fête Nationale July 14 mobile secular national 195 6 (7)
Assumption August 15 mobile religious international 227 3 (4)
All Saints' Day November 1 mobile religious international 305 4 (5)
Armistice 1918 November 11 mobile secular national 315 0 (1)
Christmas December 25 mobile religious national 359 2 (3)
St. Etienne December 26 mobile religious Alsace-Moselle 360 3 (4)
  • The column “day number” is the sequence number in the year beginning with “1” on the first of the year. The column “day mod 7” will be used for calculating the day of the week in which it falls relative to the first of the year; in parentheses, the leap year version of same.
  • Sure (by criterion of timing) : 3 (4 in Alsace-Moselle)
  • Alsace-Moselle have a couple of extra holidays for historical, Treaty of Augsburg, reasons.

Brute-Force Analysis

In which the fourteen possible years are considered, the possibilities resulting from starting the year on each of the seven weekdays, and the year being “leap” (29 days in February) or not.

Event Non Leap Years Event Leap Years
New Year's Day Mon Tue Wed Thu Fri Sat Sun New Year's Day Mon Tue Wed Thu Fri Sat Sun
Good Friday Fri Fri Fri Fri Fri Fri Fri Good Friday Fri Fri Fri Fri Fri Fri Fri
Easter Monday Mon Mon Mon Mon Mon Mon Mon Easter Monday Mon Mon Mon Mon Mon Mon Mon
Labor Day Tue Wed Thu Fri Sat Sun Mon Labor Day Wed Thu Fri Sat Sun Mon Tue
Victory 1945 Tue Wed Thu Fri Sat Sun Mon Victory 1945 Wed Thu Fri Sat Sun Mon Tue
Ascension Thu Thu Thu Thu Thu Thu Thu Ascension Thu Thu Thu Thu Thu Thu Thu
Pentecost Monday Mon Mon Mon Mon Mon Mon Mon Pentecost Monday Mon Mon Mon Mon Mon Mon Mon
Fête Nationale Sat Sun Mon Tue Wed Thu Fri Fête Nationale Sun Mon Tue Wed Thu Fri Sat
Assumption Wed Thu Fri Sat Sun Mon Tue Assumption Thu Fri Sat Sun Mon Tue Wed
All Saints' Day Thu Fri Sat Sun Mon Tue Wed All Saints' Day Fri Sat Sun Mon Tue Wed Thu
Armistice 1918 Sun Mon Tue Wed Thu Fri Sat Armistice 1918 Mon Tue Wed Thu Fri Sat Sun
Christmas Tue Wed Thu Fri Sat Sun Mon Christmas Wed Thu Fri Sat Sun Mon Tue
St. Etienne Wed Thu Fri Sat Sun Mon Tue St. Etienne Thu Fri Sat Sun Mon Tue Wed

The Concluding Tally

Now, tallying those figures, we see more readily that one never gets all eleven national holidays : at least one falls on either a Saturday or a Sunday, for an average of 61/7, or about 8.6 net holidays per year. 2011, the year in which this is being prepared, is a “year index 6”, as meager as they come, with three days lost to Sundays. It is not quite so bad in Alsace-Moselle.

Year index 1 2 3 4 5 6 7 8 9 A B C D E
Alsace-Moselle Sat 1 0 1 2 3 1 1 Sat 0 1 2 3 0 2 1
Sun 1 1 0 1 2 3 1 Sun 1 0 1 2 3 0 2
Mon-Fri 11 12 12 10 8 9 11 Mon-Fri 12 12 10 8 10 11 10
All France Sat 1 0 1 1 3 1 1 Sat 0 1 1 3 0 2 1
Sun 1 1 0 1 1 3 1 Sun 1 0 1 1 3 0 2
Mon-Fri 9 10 10 9 7 7 9 Mon-Fri 10 10 9 7 8 9 8

 
public_holidays_in_france.txt · Dernière modification: 2011/06/04 15:59 par suitable