Forum Discussion
BRI_WincVA
Jan 20, 2021Copper Contributor
Calender Templates
We are using a calendar template for our 12-hr shifts. Is there a way to 'automatically' include known holidays and also add company specific holidays?
JMB17
Jan 20, 2021Bronze Contributor
I believe it is a matter of adding a Holidays table and modifying your MOD calculation to deduct the number of holidays that come before the active/selected date. Then, in your conditional format formula, test for: cell contains a number, date does not exist in the holidays list, and the calculated shift code = A or B.
I added an example worksheet that I *think* is what you're trying to do? One other observation, is that you might consider putting your shift patterns in a table by year. Then you could make shift_pattern a named formula that looks the calendar year up in the table and it could auto-update every year.