Highlighting specific days on a calendar based on work patterns

for p2
how can we know there is an annual leave?
for halfweek:
=VLOOKUP($H11,Configuration!$D$3:$L$22,2 +WEEKDAY(Y$8,2),)

btw row10 this way is better

Hi, thanks for taking a look at this.

Originally Posted by tim201110

for p2
how can we know there is an annual leave?

The manager selects the appropriate absence code from the drop-down list. The formula essentially fills in everyone's work pattern at the start of the year, saving either myself or the manager from having to enter it manually, but the manager can manually overwrite the work pattern to show absences from the office.

for halfweek:
=VLOOKUP($H11,Configuration!$D$3:$L$22,2 +WEEKDAY(Y$8,2),)

btw row10 this way is better

I'm sorry, I don't understand. The VLOOKUP seems to just put in the work pattern the same as the existing formula, but I don't understand what you mean about row10.