Help! I'm trying to enter a formula into an Excel spreadsheet which will return the day and date on which the UK Boxing Day public holiday is observed (in the format "Monday 28 December 2015" etc.).
Boxing Day is nominally 26th December, but it is always observed on a working day, and when the Christmas Day public holiday is observed on a Monday, then it moves to the following Tuesday.
To summarise:
If 26 December is a Saturday, Boxing Day is observed on Monday 28 December.
If 26 December is a Sunday, Boxing day is observed on Tuesday 28 December.
If 26 December is a Monday, Boxing Day is observed on Tuesday 27 December.
Otherwise it is observed on 26 December.
I'm not expert enough to get my head around this, so would welcome your assistance!
Thanks in advance,
Matthew