UK Bank holidays

[agibsonsw]

Hello.
Any idea where I might obtain a list of UK bank holiday dates? I can find recent ones but I want to go back 20 or 30 years!
Andy.

[steveh]

Hi Andy

For current bank holidays I always use the Woodlands School resource, I have just had a look at some of there other stuff that might help you as a starting point
http://www.woodlands-junior.kent.sch.uk ... idays.html" onclick="window.open(this.href);return false; if I find anything else I will post back

[HansV]

See
Holidays: Early May Bank Holiday in United Kingdom
Holidays: Spring Bank Holiday in United Kingdom
Holidays: Summer Bank Holiday in United Kingdom
Holidays: Bank Holiday in United Kingdom
Holidays: Bank Holiday in United Kingdom

[agibsonsw]

Thanks both.
I'm getting there, but there's Easter to consider. And I think there must have been a few more odd days - queen's anniversary, was there a day for Diana's wedding?

[TonyE]

For Easter there is a rather bizarre Excel formula you can use, for details see http://www.cpearson.com/excel/Easter.aspx" onclick="window.open(this.href);return false;

[agibsonsw]

See
Holidays: Early May Bank Holiday in United Kingdom
Holidays: Spring Bank Holiday in United Kingdom
Holidays: Summer Bank Holiday in United Kingdom
Holidays: Bank Holiday in United Kingdom
Holidays: Bank Holiday in United Kingdom

These dates are in a weird format - the day May-05 is actually 1st May 2005!

I might give up. I'm just building some sample staff data and wanted their start dates to avoid bank holidays. I avoided dates for Christmas and new year. The probability from my small list (100 staff) of any being employed on a bank holiday is small.
Andy.

[HansV]

You'd have to add New Year's Day too.

For Easter, see Easter Dates 1901 - 2078. The dates of Easter Sunday are given in dd.mm format, but it should be easy enough to change it to dd/mm and to calculate Easter Monday.

The wedding day of Charles and Diana, 29 July 1981, was a bank holiday. The Queen's Jubilee (3 June 2002) too.

[HansV]

These dates are in a weird format - the day May-05 is actually 1st May 2005!

You want everything handed to you on a platter, don't you...

[agibsonsw]

I began the process to convert the dates but some of them had years in the 1900s rather than 2000s. As this is only for some sample data I thought it was more trouble than it was worth.
But you're right, I am a little lazy at times..

[agibsonsw]

You want everything handed to you on a platter, don't you...

You made me feel guilty so I've sorted it now. I also obtained a list of holidays from Outlook to assist.
Thanks both, Andy.

[HansV]

Sorry, I forgot to add a smiley - I was just ribbing you!

[agibsonsw]

I assumed you were

[John Gray]

As this is only for some sample data I thought it was more trouble than it was worth.

I think you ought to take up the name Bankquo, which has a literary tinge.

[HansV]

What? You want Andy to be a ghost at the feast?

[agibsonsw]

I think you ought to take up the name Bankquo, which has a literary tinge.

I'm afraid the reference eludes me. I started to do some research but gave up

[HansV]

"Banquo is a character in William Shakespeare's 1606 play Macbeth"

From: Banquo - Wikipedia, the free encyclopedia

[John Gray]

That's the chap! Shakspere wasn't really any good at spelling...

[agibsonsw]

I knew that, but I didn't understand the reference.
It might hint that I'm not a true 'geek' - not participating in the feast. I might disagree; I spent several hours trying to place banded colours behind a web page, even though it looked ugly and I had already received a nice solution to it, and I had no intention of ever using it!

[HansV]

John Gray will have to answer that, but somehow I don't think his joke was that deep - I'd guess it was meant as a play on words for its own sake.

[John Gray]

Hans is entirely correct; it was a play on works between Bank Holidays and Banquo.