Forum Discussion
Employee Attendance Tracker
So that template has ways it could be more automatic for adding new categories BUT those colors are based on conditional formatting and I don't see a way to automatically add them. In the attached I added the LATE category and added a new conditional formatting rule for that pink color. The calculations below the calendar (counts this year and last year) I changed to be based on the 'title' in the cell just above the box (i.e. "LATE") so if you have another category you could in theory just copy those cells and then update just that 1 cell... but you would still have to 'duplicate' the conditional formatting rule and update that also.
On the Calendar View sheet:
1) Select C6, then select Conditional Formatting > Manage Rules... on the Home tab of the ribbon.
Scroll down the list of rules and select the last one:
Click Edit Rule... and change the formula to
=OR(LEFT(C$5, 3)="SUN", COUNTIF(lstHolidays, C6)>0)
Click OK, then OK.
2) Select H20 and change the formula to
=NETWORKDAYS.INTL(DATE(Calendar_Year,1,1),EDATE(DATE(Calendar_Year,1,1),12)-1,11,lstHolidays)
3) Select H21 and change the formula to
=NETWORKDAYS.INTL(DATE(Calendar_Year-1,1,1),EDATE(DATE(Calendar_Year-1,1,1),12)-1,11,lstHolidays)
On the Employee Leave Tracker sheet:
Select F4, and change the formula to
=NETWORKDAYS.INTL([@[Start date]],[@[End date]],11,lstHolidays)
THANK YOU SO MUCH!!🤓