Attendance Calendar
Posted on August 7, 2009
Filed Under Calendar |
Perhaps this excel file is a combination between monthly and yearly attendance record where you can use some worksheets of this template as a printable monthly attendance forms and collect all monthly data to form employee attendance record for one year period.
This excel file consist of one worksheet of one year attendance worksheet, 12 worksheets of monthly attendance, one worksheet of holiday and one worksheet of employee data. You can enlarge a picture one year attendance worksheet above to see it clearly. In this worksheet, all you have to do just fill the ID of the employee and your targeted year. And all the employee attendance information will reveal automatically. And to make sure that all information will be revealed correctly, you have to fill correctly the rest of the worksheets.
The first worksheet that you have to fill correctly is your employee data worksheet as you can see in the picture below. Try to follow my sample inside the worksheet to understand the purpose of its column.
The second worksheet that you have to adjust after finishing the employee data worksheet is the holidays worksheet, where the data will be used to calculate the number of working days in each month.
Now, you ready to use your monthly attendance record form where you can see your employee information, number of working days and holidays mark created in those worksheets. These monthly attendance records are based on 5 working days in each weeks, from Monday to Friday. If you needs a record for 6 working days, you can adjust the formula by yourself or you can wait the next version.
—————————————————
Based on comments and emails I received, there are many request on half day and customize holidays feature. I have made the new version, V1.22, that can accommodate those requests. There are instruction and sample data inside the spreadsheet. I haven’t fully tested this version, so let me know if you have any problem on using this spreadsheet. But, I still leave the old version, V1.1, to be downloaded, just in case you don’t need those new features above.
You can download the file here :
Attendance Calendar V1.1 (322.5 KiB, 17,403 hits)
Attendance Calendar V1.22 (334.5 KiB, 686 hits)
You can read and download my other templates below :
- Islamic Calendar
- 2010 Calendar
- Daily Planner
- Bill Payment Calendar
- Weekly Calendar
- Academic Calendar 2009/2010
- Monthly Calendar
- Monthly Event Calendar 2009
Comments
43 Responses to “Attendance Calendar”
Leave a Reply
Hey, that’s a pretty useful calendar. Did you create it yourself?
Can’t get the summary page to pick up postings on the months. Is there a secret somewhere. When I use your template it doesn’t work either.
Hi Dear,
Sj is right Summary page is not working correctly and we are unable to get summary of Present Sick Vacation Other Not Working Yet/Anymore
Thx
Hi Adnan,
Thank you for your reminder. I read comment written by Sj, but I forgot to fix that up quickly. There is some error in the vlookup formula, but it is fixed now. You can download the new version.
And for Sj, sorry for late response.
Regards
can you teach me how to do it in excel.
Thanks!
Thanks so much for this! This is very useful, Ive been looking for semething like this for a long time.
Thanks again!
As pointed out in the comments from where can i download the latest version of this calender? as summary page is not bringing up th data entered in other pages in this version.
It’s already fixed. You can download through the same download link. Tks.
Hi there,
This has been fantastic, however, how do you calculate half a day in the month spreadsheets? Ie - S totals one day, how would you total 0.5?
Hi,
This is Mathi from India, Chennai. I find your attendance very useful.
Would it possible to share the macros code as to who you are capturing and validating the data for the particular “employee id”.
I have about 1000 records for whom i need to fetch relevant details for salary revision etc.
It would be great if you could share the same.
Regards,
Mathi
In response to Rachel (Oct 27th 2009). Regarding the need for processing 1/2 days; I have taken this workbook and ammended it to account for 1/2 days as well as showing holidays in blue. I would be glad to share.
@ Mathi : There is no macro inside the spreadsheet. You can modify it to suit your needs.
@Charles : Thanks for sharing. You can also put your link here, so everybody can download through your link.
Regards.
Thank you so much!
That would be great if you could pls let me know how you have added the half days, I have already formatted the spreadhseet to suit my work place, so dont want to have to re do it all witha new one.
Also how come the weekends cant not be chanegd in colour?
I want to copy the spreadhseet I have created for 09 and amend it to 2010..I await your reply
Thanks again for your assistane!
Sorry to be a bit more clearer I want to just use this spreadhseet each year and manually add the weekends etc…But the 09 one I have used I can not do this.
Can youu please assist.
Thanks again
I would like to add to the attendance calendar columns titled Unexcused Absence (UE),Tardy(T), Personal(PD) and have those columns that I add to tally the number of each of those accurances thoughout the year for each month. I can’t seem to get the formula or VLOOKUP function to work correctly. can anyone help with this?
Thanks,
You answered Rachel & said you made a modification to the attendance spreadsheet so a half day can be calculated. Can you send that new spreadsheet to me. I will make the appropriate changes in my company populated version. Also my working days comes up (#Name?)what may be causing this, I have put in my holidays; it looks like it is looking for another worksheet or something. Thanks and good job on this sheet.
Ken
Was there any luck with the above requests?
Thank you
How exactly do you download off of your site? I have tried repeatedly and it doesn’t seem to want to download. Am I doing something wrong?
Rachel or Charles - I also have the need to include half-days in my employee calendar, so please share if you have updated this!
I am facing “#NAME?” error in “Working Days”. Plz tell me the solution.
How do you adjust the holidays or add new ones?
I am also getting the #NAME error in “Working Days”. I have not been able to follow the formula to correct it. I am also in need of help with the Holidays calculation, 1/2 day calculation and getting rid of the gray background weekend columns. If anyone has figured these out, please help me! Thanks! vidahlia at yahoo dot com
This is brilliant - just what I needed - thank you.
The only thing I am now struggling with is putting in the UK Bank Holidays for 2010 which I have tried to look at the code to re-write, but it seems quite complex. The UK 2010 Bank Holidays are as follows:
New Year’s Day January 1
Good Friday April 2
Easter Monday April 5
Early May Bank Holiday May 3
Spring Bank Holiday May 31
Summer Bank Holiday August 30
Christmas Day Holiday December 27
Boxing Day Holiday December 28
Any help would be very appreciated.
Thanks,. it works.
Hi, this is brilliant, but how do I modify it to work for for 2010
I Want To Know How We Change 5days Working to 6 days
Very good calendar. How do you get the # of days to calculate for each month? The summary page displays #NAME for working days? Also, all months end on day 28 and just shows # on top and bottom of cells for continuation. I did discover I can copy the previous cell to correct it but I should not have to do that for each month. Suggestions appreciated.
Did anyone ever get any help with the 1/2 day (or partial day) issue? I also need the capability for occasional Saturday work. Otherwise, this is a great spreadsheet!!!
How do I translate to 2010.
This spreadsheet is great, very helpful - but like some others above, we need help tracking 1/2 days, is there a way to do that? Thanks!
I am also getting the error in the Work Days. Can someone help me in fixing. Thanks!!
thx.. this is very good, your effort is much appreciated.
Q. we work Mon-Sat. how do i make the changes? cause the networkdays formula calculates sat & sun as public holiday.
Was there a fix for the error with Work Days? If anyone has figured these out, please help me!
Hi again, as mentioned above, we’re trying to set this up to use but need to know what to do about 1/2 days - it looks like there is a fix from comments above, but I can’t find a link on here, what can I do? Thanks very much for your help with this!
Thank you for all of your feedbacks. I have created the new version that can accommodate your needs on customize working days and possibility of putting half day working time.
Regards
Hello, I am trying to input our holidays in the second version, and they are not populating in the pages, it also changed the formula of “working days” per month to “value” and I can’t change it.
Also, I need to add personal birthday per employee, because they get that day off, or, a day near it.
Dear Admin,
thank you for the second version
i only changed the working days in the setting and saved the file when i re-open it, it shows “#VALUE!” in the working days column for all the months. i even tried a fresh copy by saved it on the desktop, opened it and saved it without making changes. still shows the same error#VALUE!
please help..
@Patti and mohamad,
I think it related to a default setting in your excel software. But, could you send me your file to my email so I can see whether your problem is caused by your excel setting or other problem?
Regards
Dear Admin,
What is your email address
regards
Hey all,
To fix the “Name” problem under working days go to tools and unprotect the sheet. This is what I did and it worked.
Hey that is a brillant spreadsheet. Just love it. But can anyone help me how to enter 1/2 P (Present) or 1/2 day S (sick)??? Thank you. Rene rene_wenger@hotmail.com
@Mohamad : info@exceltemplate.net
@Rene : Just type the number (0.5) and the formula will calculate it together with P for Present. It only works in V1.22.