Employee Absence Schedule

[RHoward824]

I have used the scheduler as a template to build a leave tracker that works for my office however, I'm having a difficult time highlighting the days our office is closed. I can get it to highlight for 2022 but when I change the year, the highlighted cell do not change with the days. I want the tracker to change the cells for those days with the days and numbers for any year I put in. Is that possible or do I have to manually do it every year?

[#2]

@RHoward824 

The possibilities for the user in Excel...many, as well as the error possibilities :).

All error possibilities are open, conditional formatting error?, formula error?, VBA code content?, formula incompatibility with possible new excel version?...etc..etc..

With your permission, if I may recommend, add a file (without sensitive data).

Based on this file, explain your request/topic/problem step by step.

Inform us about your Excel version, operating system and storage medium (hard drive, OneDrive, Sharepoint, etc.).

So you could get a much quicker and more accurate solution suggestion and the helpers don't need to solve the guessing game beforehand, they could focus on the error source.

Anyway is just a recommendation :).

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)