Forum Discussion
Employee Attendance Tracker
Is there a video on creating this type of template?
If not can I add to the types of leave?
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.
15 Replies
Hi, I have downloaded this template but unfortunatly i can not see the attendance on the table weekday/month in the calendar view sheet. The table in blank i click on an cell the formula is there but no results no days are highlighted. The key statistics information work well for every employee.
How can i make it work so that i can view the leave days?
Anybody know how to add Saturday as working/network day?
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!!🤓
Please check this article.
This explains step by step process of creating an attendance tracker in excel:
https://www.workstatus.io/blog/time-attendance/mastering-excel-for-attendance-tracking/- I am able to get a copy of this please?????
Could you say a bit more about your situation? Those two questions seem quite distinct and close to un-related to each other, given that attendance tracking would be about a LOT more than simply types of leave. What kind of situation is this; what size of organization? How detailed does the tracking need to be (hours, minutes, days?)...by type of employee (FT, PT, etc?) etc etc
I haven't found any such templates in this link for Microsoft templates. You might try googling. Or YouTube.
https://templates.office.com/en-us/premium-templates/planners-and-trackers?page=2
I downloaded the employee attendance tracker template. It works for what I need but I would like to add a couple "leave types". when I added one to the leave type sheet it is not showing on the main page.
The last square that says Late is the one we added but it is not showing on the front page.
I apologies for not having the proper words to explain exactly what I need to know.
- I would love to have a copy of this please!!!!
