Hi,
I am using the "Employee Attendance Tracker" template from Excel 2013 templates section (attached). The template is fine as is but I want it to do two more things:
1. I want the entire row of the current month to be highlighted automatically on the 1st Tab (Calendar View)
2. I need the template to count the total number of employees that are absent on any given date.
Edit: Just to be clear, I need the total number of absentee employees on a given date in that same year in a separate table somewhere below the Key Statistics Area on the Calendar View.
For example:
If 4 employees are absent on 28th July 2016, I want 4 to be displayed against 28th July in a separate table somewhere on the 1st Tab (Calendar View).
Is there any way to achieve this?
Bookmarks