Employee Absence Schedule

%3CLINGO-SUB%20id%3D%22lingo-sub-3185648%22%20slang%3D%22en-US%22%3EEmployee%20Absence%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3185648%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20used%20the%20scheduler%20as%20a%20template%20to%20build%20a%20leave%20tracker%20that%20works%20for%20my%20office%20however%2C%20I'm%20having%20a%20difficult%20time%20highlighting%20the%20days%20our%20office%20is%20closed.%20I%20can%20get%20it%20to%20highlight%20for%202022%20but%20when%20I%20change%20the%20year%2C%20the%20highlighted%20cell%20do%20not%20change%20with%20the%20days.%20I%20want%20the%20tracker%20to%20change%20the%20cells%20for%20those%20days%20with%20the%20days%20and%20numbers%20for%20any%20year%20I%20put%20in.%20Is%20that%20possible%20or%20do%20I%20have%20to%20manually%20do%20it%20every%20year%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3185648%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3187229%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20Absence%20Schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3187229%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310744%22%20target%3D%22_blank%22%3E%40RHoward824%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThe%20possibilities%20for%20the%20user%20in%20Excel...many%2C%20as%20well%20as%20the%20error%20possibilities%20%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAll%20error%20possibilities%20are%20open%2C%20conditional%20formatting%20error%3F%2C%20formula%20error%3F%2C%20VBA%20code%20content%3F%2C%20formula%20incompatibility%20with%20possible%20new%20excel%20version%3F...etc..etc..%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWith%20your%20permission%2C%20if%20I%20may%20recommend%2C%20add%20a%20file%20(without%20sensitive%20data).%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EBased%20on%20this%20file%2C%20explain%20your%20request%2Ftopic%2Fproblem%20step%20by%20step.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EInform%20us%20about%20your%20Excel%20version%2C%20operating%20system%20and%20storage%20medium%20(hard%20drive%2C%20OneDrive%2C%20Sharepoint%2C%20etc.).%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3ESo%20you%20could%20get%20a%20much%20quicker%20and%20more%20accurate%20solution%20suggestion%20and%20the%20helpers%20don't%20need%20to%20solve%20the%20guessing%20game%20beforehand%2C%20they%20could%20focus%20on%20the%20error%20source.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EAnyway%20is%20just%20a%20recommendation%20%3A).%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

1 Reply

@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)