Forum Discussion
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?
6 Replies
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.
BRI_WincVA Which template exactly?
Work Calendar with a 2nd tab for Shift Pattern.
Where to find it ? It's better to attach template as a file.
