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.
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)
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?
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.