Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

United Kingdom Public holidays

51 views
Skip to first unread message

Gary Haslam

unread,
Aug 18, 2000, 3:00:00 AM8/18/00
to
Dear all,
I'm trying to build a spreadsheet which calculates the UK Public
holidays.
In the UK there are annually, 8 public holidays. These are as follows:

New Years Day: 1 January or if it falls on a Saturday or Sunday, the first
Monday after that date.
Good Friday: The Friday before Easter Sunday
Easter Monday: The Monday after Easter Sunday

Early May Bank Holiday: The first Monday in May
Spring Bank Holiday: The last Monday in May
SummerBank Holiday: The last Monday in August

Xmas Day: 25 December or or if it falls on a Saturday or Sunday, the first
Monday after that date
Boxing Day: 26 December or if it falls on a Saturday or Sunday, the first
non-public holiday weekday after that date.
(This is in case Xmas day is on a Saturday and Boxing day is on a Sunday,
when the Public holidays would be 27 and 28 which in this case would be
Monday and Tuesday!)

What I'd like to be able to do is be able to calculate them for any year
from say 1999 to 2004.

Any and every help would be appreciated.
Regards.................Gary

Bernard Liengme

unread,
Aug 18, 2000, 3:00:00 AM8/18/00
to Gary Haslam

Hi,
Gary,
I will reply privately with pages from my book.
Bernard

Chip Pearson

unread,
Aug 18, 2000, 3:00:00 AM8/18/00
to
Gary,

I have a whole page on my web site with both VBA code and Excel formulas for
determining the dates of various holidays. See
http://www.cpearson.com/excel/holidays.htm for more information.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com


"Gary Haslam" <gary....@royalblue.com> wrote in message
news:#MCjGbRCAHA.247@cppssbbsa04...

Gary Haslam

unread,
Aug 21, 2000, 3:00:00 AM8/21/00
to
Hi Bernard, Chip
Thanks for your help.
Appreciate the input,
Best regards...............Gary

Myrna Larson

unread,
Aug 21, 2000, 3:00:00 AM8/21/00
to

On Mon, 21 Aug 2000 14:18:40 +0100, "Gary Haslam" <gary....@royalblue.com>
wrote:

>Thanks for your help.
>Appreciate the input,

I didn't see the rest of this thread, but if you haven't solved your problem,
I have some VBA code that generates US holidays. If you are interested, I can
email you the workbook with code modified for UK holidays you show below. It
is for XL2000, and won't work with XL97 without changes.

0 new messages