Holidays

A holiday is a day designated as having special significance for individuals, governments or religious groups. Typically, a holiday does not necessarily exclude doing normal work but for our purposes, NumXL assumes all supported holidays (e.g. National Holidays) exclude normal work.

Observed holidays and actual dates for particular holidays (e.g. Easter) may vary between countries, so in NumXL a holiday code is prefixed by the country ISO code (e.g. USA, CAN, GBR, etc.).

As of version 1.56 (Zebra), NumXL supports 117 different holidays in the following 10 countries:

Country  
United States (USA)
Code Description
USA-NYD New Year’s Day
USA-MLK Birthday of Martin Luther King, Jr.
USA-PRS Birthday of George Washington
USA-MEM US Memorial Day
USA-IND US Independence Day
USA-LAB US Labor Day
USA-COL Columbus Day
USA-VET US Veterans Day
USA-THK US Thanksgiving Day
USA-CHR Christmas Day
USA-GDF US Good Friday
Canada
Code Description
CAN-NYD New Year's Day in Canada
CAN-GDF Good Friday in Canada
CAN-VICTORIA Victoria Day in Canada
CAN-CANADA Canada Day
CAN-CIVIC Civic/Provincial Day in Canada
CAN-LABOR Labour Day in Canada
CAN-THK Thanksgiving Day in Canada
CAN-REM Remembrance Day in Canada
CAN-CHR Christmas in Canada
CAN-BOX Boxing Day in Canada
EU Countries (EUC)
Code Description
EUC-CHR Christmas Day
EUC-BOX Boxing Day
EUC-MAY May Day
EUC-GDF Good Friday
EUC-EAST Easter Monday
EUC-NYD New year - Unadjusted
Great Britain (GBR)
Code Description
GBR-NYD New Years in Britain
GBR-GDF Good Friday
GBR-EAST Easter Monday
GBR-MISC Royal Wedding Bank Holiday
GBR-EMAY Early May Bank Holiday
GBR-MAY Spring Bank Holiday
GBR-SUMMER Summer Bank Holiday
GBR-BOX Boxing Day
GBR-CHR Christmas
GBR-MISCBABK Bank Holiday
Switzerland (CHE)
Code Description
CHE-BERCH Berchtold Day
CHE-NYD New Year's day
CHE-GDF Good Friday
CHE-EAST Easter Monday
CHE-MAY May Day in Switzerland
CHE-ANS Ascension Day
CHE-WIT Whit Monday
CHE-NATIONAL Swiss National Day
CHE-STEPHEN St. Stephen's Day in Switzerland
CHE-CHR Christmas Day
Japan (JPN)
Code Description
JPN-NYD New Year's Day
JPN-NYD2 January 2
JPN-NYD3 January 3
JPN-AGE Coming of Age Day in Japan
JPN-FOUND National Foundation Day
JPN-EQUINOX Spring Equinox in Japan
JPN-SHOWA Shōwa Day in Japan
JPN-MEM Constitution Memorial Day in Japan
JPN-GREEN Greenery Day in Japan
JPN-CHILD Children's Day in Japan
JPN-SEA Sea Day in Japan
JPN-RESPECT Respect for the Aged Day in Japan
JPN-AUTEQUINOX Autumn Equinox in Japan
JPN-SPORT Sports Day in Japan
JPN-CULTURE Culture Day in Japan
JPN-LAB Labor Thanksgiving Day in Japan
JPN-EMPR Emperor's Birthday in Japan
JPN-DEC31 December 31 Bank Holiday
Australia (AUS)
Code Description
AUS-NYD New Year's Day in Australia
AUS-NATION Australia Day in Australia
AUS-GDF Good Friday in Australia
AUS-EAST Easter Monday in Australia
AUS-ANZAC Anzac Day in Australia
AUS-MISC Additional Public Holiday in Australia
AUS-QUEEN Queen's Birthday in Australia
AUS-NSWALES New South Wales Bank Holiday in Australia
AUS-LAB Labour Day in Australia
AUS-BOX Boxing Day in Australia
AUS-CHR Christmas Day in Australia
AUS-CHRBOX Christmas/Boxing Day Holiday in Australia
New Zealand (NZL)
Code Description
NZL-NYD New Year's Day in New Zealand
NZL-NYD2 Day after New Year's Day in New Zealand
NZL-WAIT Waitangi Day in New Zealand
NZL-GDF Good Friday in New Zealand
NZL-EAST Easter Monday in New Zealand
NZL-ANZAC Anzac Day in New Zealand
NZL-QUEEN Queen's Birthday in New Zealand
NZL-LAB Labour Day in New Zealand
NZL-CHR Christmas Day in New Zealand
NZL-BOX Boxing Day in New Zealand
Saudi Arabia (SAU)
Code Description
SAU-NATION Saudi National Day in Saudi Arabia
SAU-FITR Eid-al-Fitr
SAU-ADHA EID EL-ADHA
Israel (ISR)
Code Description
SAU-NATION Saudi National Day in Saudi Arabia
ISR-PURIM Purim (Deliverance of the Jews) in Israel
ISR-PESACHI Pesach I (First day of Passover) in Israel
ISR-PESACHVII Pesach VII (Last day of Passover) in Israel
ISR-HOLO Holocaust Memorial Day in Israel
ISR-MEM Memorial Day in Israel
ISR-IND Independence Day in Israel
ISR-PENT Shavuot (Pentecost) in Israel
ISR-TISHA Tisha B'Av in Israel
ISR-ROSH Rosh Hashana (New Year) in Israel
ISR-KIPPUR Yom Kippur in Israel
ISR-SUKKOT Sukkot I in Israel
ISR-SIMCHAT Simchat Torah
ISR-CHANUKAH Holiday of lights (Chanukah)

Remarks

  • A holiday may span multiple days (e.g. EIDS for muslims).
  • The holiday code has a "(COUNTRY [-/:]) CODE" covention, where the country (optional) is denoted by a 3-character ISO code (e.g. GBR, CAN, etc.).
  • In case a holiday code is given without a country prefix, The default of USA is assumed.
References

 

Have more questions? Submit a request

0 Comments