Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CSV for all US bank holidays till 2020. First row is the header. Dates are MYSQL format.
1,2012-01-02,New Year Day
2,2012-01-16,Martin Luther King Jr. Day
3,2012-02-20,Presidents Day (Washingtons Birthday)
4,2012-05-28,Memorial Day
5,2012-07-04,Independence Day
6,2012-09-03,Labor Day
7,2012-10-08,Columbus Day
8,2012-11-12,Veterans Day
9,2012-11-22,Thanksgiving Day
10,2012-12-25,Christmas Day
11,2013-01-01,New Year Day
12,2013-01-21,Martin Luther King Jr. Day
13,2013-02-18,Presidents Day (Washingtons Birthday)
14,2013-05-27,Memorial Day
15,2013-07-04,Independence Day
16,2013-09-02,Labor Day
17,2013-10-14,Columbus Day
18,2013-11-11,Veterans Day
19,2013-11-28,Thanksgiving Day
20,2013-12-25,Christmas Day
21,2014-01-01,New Year Day
22,2014-01-20,Martin Luther King Jr. Day
23,2014-02-17,Presidents Day (Washingtons Birthday)
24,2014-05-26,Memorial Day
25,2014-07-04,Independence Day
26,2014-09-01,Labor Day
27,2014-10-13,Columbus Day
28,2014-11-11,Veterans Day
29,2014-11-27,Thanksgiving Day
30,2014-12-25,Christmas Day
31,2015-01-01,New Year Day
32,2015-01-19,Martin Luther King Jr. Day
33,2015-02-16,Presidents Day (Washingtons Birthday)
34,2015-05-25,Memorial Day
35,2015-07-03,Independence Day
36,2015-09-07,Labor Day
37,2015-10-12,Columbus Day
38,2015-11-11,Veterans Day
39,2015-11-26,Thanksgiving Day
40,2015-12-25,Christmas Day
41,2016-01-01,New Year Day
42,2016-01-18,Martin Luther King Jr. Day
43,2016-02-15,Presidents Day (Washingtons Birthday)
44,2016-05-30,Memorial Day
45,2016-07-04,Independence Day
46,2016-09-05,Labor Day
47,2016-10-10,Columbus Day
48,2016-11-11,Veterans Day
49,2016-11-24,Thanksgiving Day
50,2016-12-25,Christmas Day
51,2017-01-02,New Year Day
52,2017-01-16,Martin Luther King Jr. Day
53,2017-02-20,Presidents Day (Washingtons Birthday)
54,2017-05-29,Memorial Day
55,2017-07-04,Independence Day
56,2017-09-04,Labor Day
57,2017-10-09,Columbus Day
58,2017-11-10,Veterans Day
59,2017-11-23,Thanksgiving Day
60,2017-12-25,Christmas Day
61,2018-01-01,New Year Day
62,2018-01-15,Martin Luther King Jr. Day
63,2018-02-19,Presidents Day (Washingtons Birthday)
64,2018-05-28,Memorial Day
65,2018-07-04,Independence Day
66,2018-09-03,Labor Day
67,2018-10-08,Columbus Day
68,2018-11-12,Veterans Day
69,2018-11-22,Thanksgiving Day
70,2018-12-25,Christmas Day
71,2019-01-01,New Year Day
72,2019-01-21,Martin Luther King Jr. Day
73,2019-02-18,Presidents Day (Washingtons Birthday)
74,2019-05-27,Memorial Day
75,2019-07-04,Independence Day
76,2019-09-02,Labor Day
77,2019-10-14,Columbus Day
78,2019-11-11,Veterans Day
79,2019-11-28,Thanksgiving Day
80,2019-12-25,Christmas Day
81,2020-01-01,New Year Day
82,2020-01-20,Martin Luther King Jr. Day
83,2020-02-17,Presidents Day (Washingtons Birthday)
84,2020-05-25,Memorial Day
85,2020-07-03,Independence Day
86,2020-09-07,Labor Day
87,2020-10-12,Columbus Day
88,2020-11-11,Veterans Day
89,2020-11-26,Thanksgiving Day
90,2020-12-25,Christmas Day
@AldenPeterson

This comment has been minimized.

Copy link

commented Nov 22, 2013

THANK YOU for this. I've spent a lot of time trying to find this info.

@shivaas

This comment has been minimized.

Copy link
Owner Author

commented May 26, 2014

@enderland glad this could help you :)

@haleemur

This comment has been minimized.

Copy link

commented Sep 16, 2014

Thank you for this. I think the first entry should be 2012-01-01 instead of 2012-01-02

@craigxgibbons

This comment has been minimized.

Copy link

commented Mar 25, 2015

Thanks for this, but it seems to be missing Good Friday:
2015-04-03
2014-04-18
2013-03-29
2012-04-06
...

@jameslin101

This comment has been minimized.

Copy link

commented Mar 30, 2015

Thanks for the list!
Those bank holidays are actually correct:
@haleemur New year in 2012 fell on a sunday so monday is the holiday
@craigxgibbons Also Good Friday is not a bank holiday but is a stock market holiday.
Veterans Day and Columbus Day are bank holidays but are not stock market holidays
If you are looking for US Stock market holidays I've created a different gist here
https://gist.github.com/jameslin101/cf2860eba52a56281427

@SteveSether

This comment has been minimized.

Copy link

commented Sep 15, 2015

Hi, I'd just like to warn anyone using this list that it's inaccurate. For instance, the Federal Holiday of Christmas is NOT always observed on Dec 25th. If Christmas day falls on a Saturday, the holiday is observed on Friday the 24th. If Christmas day falls on a Sunday, the holiday is observed on the 26th. Look at 2016, when Christmas day is a Sunday, but the list specifies the observed holiday on the 25th, when it should be the 26th.

New Years Day appears to be accurate, but I haven't looked at it extensively. But don't rely on this list for bank holidays since it's just wrong.

@thejosephstevens

This comment has been minimized.

Copy link

commented Dec 16, 2015

Thanks so much for making this, it just made my job a whole lot easier.

@alkutnikar

This comment has been minimized.

Copy link

commented Jan 6, 2017

This is helpful!

@srumbalski

This comment has been minimized.

Copy link

commented Jan 12, 2017

"50,2016-12-25,Christmas Day" should be "50,2016-12-26,Christmas Day" as 2016-12-25 was a Sunday.
I ran the rest of the dates and made sure that none of the others were on a Saturday or a Sunday.
2021 data is available (see https://www.federalreserve.gov/aboutthefed/k8.htm):
Here it is formatted to append to your csv:
91,2021-01-01,New Year Day
92,2021-01-18,Martin Luther King Jr. Day
93,2021-02-15,Presidents Day (Washingtons Birthday)
94,2021-05-31,Memorial Day
95,2021-07-05,Independence Day
96,2021-09-06,Labor Day
97,2021-10-11,Columbus Day
98,2021-11-11,Veterans Day
99,2021-11-25,Thanksgiving Day
100,2021-12-24,Christmas Day

@tinohager

This comment has been minimized.

Copy link

commented Jan 14, 2018

if anyone search a solution for more countries you can found it here Nager.Date

@ISAMMHADI90

This comment has been minimized.

Copy link

commented Sep 12, 2018

@ISAMMHADI90

This comment has been minimized.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.