# Formula for end-of-year holiday week

1. ## Formula for end-of-year holiday week

Dear Excel wizards,

I am trying to find an Excel non-VBA formula/function to automatically calculate the end-of-year holiday week based on the available yearly data.

These are the holiday data (including the 25th of December and the 1st and 2nd of January the next year):

Monday 26 - Friday 30 December 2016
Monday 25 - Friday 29 December 2017
Monday 24 - Monday 31 December 2018
Tuesday 24 - Tuesday 31 December 2019
Thursday 24 - Thursday 31 December 2020
Thursday 23 - Friday 31 December 2021
Friday 23 - Friday 30 December 2022
Monday 25 - Friday 29 December 2023

2. ## Re: Formula for end-of-year holiday week

You have to come up with a consistent rule: for 12/25 on a Sunday, you have both Monday - Friday (2016) as well as Friday - Friday (2022). And you are not showing what you want to do with Jan 2 when Jan 1 is a weekday....

3. ## Re: Formula for end-of-year holiday week

I will add some additional details on the holidays of the years 2016-2023. Probably the holidays during the year that fall on a weekend day are taken into account in the end-of-year holiday calculations?

Overview holidays 2016-2023.jpg

4. ## Re: Formula for end-of-year holiday week

That still shows the inconsistency between 2016 and 2022 - which makes creating a formula difficult

There are currently 1 users browsing this thread. (0 members and 1 guests)