I’ve attached attendance report format for you guys. This format will help you to track the attendance daily, weekly and monthly. The best part is, in this format you can find first week report in the Sheet-1 and second week report in the Sheet-2 and so on… and on the last Sheet you can find the Month End Report automatically updated. All are formula based.. so you don’t have to do any thing…you just have to fill in the week days as given below.
For present = “P”
For absent= “A”
For Leave= “L”
For Off= “Off”.
Just update the First Sheet with Employee Name, Employee Id, Designation, and Department… and the rest of the sheet will be update automatically.
Hope this format was helpful for you. Kindly comment with your feedback.
Many thanks…and have a rocking day…
I've newly joined into this group and i would like to appreciate your hard work but a small clarification, since most of the companies use the software's to update the attendance, but in my company we use excel to calculate even time...so kindly let me know how do you calculate timings since our off timings is from 9:30 to 18:30.
Awaiting your reply at the earliest.
Why Vote? User validation is extremely important for good content to prosper.