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
Bookmarks