List of Public Holidays for past and future years

karraj

Board Regular
Joined
Mar 5, 2002
Messages
76
Anybody know of a place to get holiday dates in excel format

Thanks in advance
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
On 2002-03-11 14:54, karraj wrote:
Anybody know of a place to get holiday dates in excel format

Thanks in advance

>Anybody know of a place to get holiday dates in excel format

It does depend where your from, I have UK dates til 2006 from 1998.
 
Upvote 0
Hi

as you know im London, and as such work worldwide ie England Ireland Scotland Wales, but also US Eire and France, can these be covered, if you have these already can you post up or email me on my profile, would help me a lot, i never know what hols are where.

If you could would help me a great deal..

Many thanks
 
Upvote 0
Outlook has these available for import into the calendar. Seemslike they should be able to be used somehow. Anybody know how?
 
Upvote 0
Don't know if this will help, but I created a worksheet that tells you the dates of 8 holidays (7 U.S. and 1 Hawaiian). All you do is input any year in cell B2 to display the dates they occur on for that year - (N.Y., IND. DAY, & XMAS of course, do not change).

Send me an email if you would like a copy (don't worry, no macros in this one).

Aloha!

(p.s. holidays I have are: NY, EASTER, MEMORIAL DAY, KAMEHAMEHA DAY, INDEPENDENCE DAY, LABOR DAY, THANKSGIVING, AND XMAS)
 
Upvote 0
Outlook has these available for import into the calendar. Seemslike they should be able to be used somehow. Anybody know how?

I am looking for the same. I would appreciate a sheet with all public holidays by ISO country code (or if necessary split by state) for most countries worldwide. Anyone found it since the thread started in 2002?

pi
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top