Of course, you can now make all sorts of adjustments according to your own wishes, and appropriate borders or fonts and much more. to change. The best thing about this form of calendar, however, is that you can reuse it for every year. Because you only need to change the year number above as the main reference point so that the Excel holiday calendar dynamically adjusts all other values.
You can easily adapt this to your own needs. Tip: You could also use the “Conditional Formatting” for entries such as HOLIDAY or SICK and, for example, enter them in color.
If you change the year on our calendar, you may be surprised that the holidays are suddenly not displayed for the selected year. This is because the date values in the holiday table refer to the VLOOKUP not only the day but also the year, and of course these are no longer found in the table in accordance with the changed year.
However, this can be easily solved by also entering the holiday values in the table with the appropriate year after changing the year.