United Kingdom holiday/vacation data

  • Thread starter Thread starter Mike Moran
  • Start date Start date
M

Mike Moran

Does anyone have a worksheet with vacation dates for the next year or two
for the United Kingdom (e.g. bank holidays, religious holidays, etc.,
etc....), or know where I can find one? I often need it to calculate working
days / exclude non-working days.

Thanks

Mike
 
Hi

Here are some formeln from Andreas Kleinert (I found them in some posting,
and saved for some future occassion. I edited them a bit here, as they were
for German Excel) - maybe you do find here something passable.

Good Friday= ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 -2
Easter= ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6
Easter Monday=ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 +1
Ascension Day=ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 +39
Mother's Day= (DATE($A$1,5,1))+15-(WEEKDAY((DATE($A$1,5,1)),1))
Whitsunday= ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 +49
Whit Monday= ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 +50
Corpus Christi=ROUND((DAY(MINUTE($A$1/38)/2+55)&".4."&$A$1)/7,)*7-6 +60
1. Advent= (DATE($A$1,12,25))-(WEEKDAY((DATE($A$1,12,25)),2))-21
2. Advent= (DATE($A$1,12,25))-(WEEKDAY((DATE($A$1,12,25)),2))-14
3. Advent= (DATE($A$1,12,25))-(WEEKDAY((DATE($A$1,12,25)),2))-7
4. Advent= (DATE($A$1,12,25))-(WEEKDAY((DATE($A$1,12,25)),2))
Christmas Eve=DATE($A$1,12,24)
Christmas Day=DATE($A$1,12,25)
Boxing Day= DATE($A$1,12,26)
New Year's Eve=DATE($A$1,12,31)
 
I forgot to mention, that the cell A1, the formulas are referring to,
contains year (4-digit number >=1900).
 
Back
Top