Employee Attendance Tracker

11 thoughts on “Employee Attendance Tracker”

1. Jules March 1, 2011 at 5:13 AM

   I am running it on Excel 2008 version 12.2.8 for MAC. There are different formula in this template and i do not know what to fill it for the space under date in the 1st Q, 2nd Q, 3rd Q, 4th Q to activate the formula. Please advise. Thanks.
2. Admin March 1, 2011 at 5:26 AM

   Good morning,

   In this workbook book, you are provided about 9 spaces to enter your employee names for each month in column A. You can manually color code the type of absence by using the fill color feature in Excel.

   If you wanted a workbook that was more automated by formulas, try this one…http://www.myexceltemplates.com/2011-employee-attendance-tracker/ I think you may be referring to this spreadsheet instead of the one you commented on….

   Please advise…
3. Jules March 1, 2011 at 5:30 AM

   Sorry for the confusion. I am using http://www.myexceltemplates.com/2011-employee-attendance-tracker but on the 1st Q page, what should i fill in to indicate an employee has taken one day or half off under a particular date. For example, if Jane Doe takes half day (AM) off on Jan 5th 2011, what exactly should i put in the box under the date Jan 5th, 2011?? Hope I made my question more understandable this time. Thanks again!
4. Admin March 1, 2011 at 5:30 AM

   Have you tried using the letters v, p, and s on the days the employee was absent? These letters should tally the appropriate sick, vacation and personal days in the year to date summary page…Ignore the previous email, I can see the post you are referring to now…
5. Admin March 1, 2011 at 5:33 AM

   This template only calculates full days so when you add the p or v to notate the absence, a full day is calculated. We will work on developing a future template that accounts for partial days. Sorry for this doesn’t fix your problem. I will keep your email on file and send you the revised template when it is complete.
6. Jules March 1, 2011 at 5:40 AM

   oh i have not tried using those letters!
   I would love to receive a revised template from you Thanks for your help!

   May I suggest one more thing because most employees don’t start their first days on 1st Jan (or any other day in Jan) of a year, it has become hard to keep track of their annual leave with this template. I understand it might be the best you can offer for now but if you can solve that problem, it would be awesome! Keep up the good work and thank you so much for your prompt reply.
7. RG March 2, 2011 at 9:14 PM

   I don’t get a template when I download using either of the links. I only get a zip file with pieces of xml. How do I get the xlsx file to open in excel or how do I use the xml files in the zip file?

   Thanks
8. RG March 2, 2011 at 9:20 PM

   I got it to download properly using Firefox. IE8 won’t download the file properly.

   Thanks
9. Heidi August 11, 2011 at 12:54 PM

   How can I change the dates easily?
10. Admin August 11, 2011 at 1:07 PM

    You should be able to manually click on the date and change them. They aren’t linked so it will be a manual process. In future edits, we will link them to expedite changes….

    Admin – My Excel Templates
11. Amy April 6, 2012 at 2:48 PM

    This is a wonderful template! For my tracking purposes I need to either add Tardies and Clocking Errors as additional columns, or replace 2 of Sick/Vacation/Personal with (T)ardy and (C)locking (E)rror. How can I do this and still maintain functionality?