Employee attendance tracker

Sounds like you just need to look into the =COUNTIF(range,criteria) function...

I don't have any employee attendance tracker templates, but there are many places on the web to help get you started.

Here are just a couple:
http://office.microsoft.com/en-us/te...001229125.aspx
http://www.vertex42.com/ExcelTemplat...-tracking.html

If you get stuck, maybe post what you have built so far and we could give some direction.

Hi Jeff,

I have prepared the attendance tracker, but the problem i am facing is Leave details are on the first sheet and Months are on different sheets when i am trying to apply "Countif" function(in cell E4) its giving me Error message "circular reference warning". what i am looking for is Leave details which is given a details page tells Maximum number of days that particular leave can be allotted, and under balance leave i wanted to track how many leave are pending of each kind for all the employee for the whole year, and i will be freezing Column A to D"
I am not really good at Excel,So Any suggestion to improve or add the tracker i will be really happy to hear.Book1.xlsx

Hey ncmay, Thanks for sharing that file. That File is really good but too complicated for me Explain to my supervisor i mean the "Formula part". can't it be possible to put in simple format(the file i attached), Including that "Drop down","Enter the year part" and "change of color after certain percentage or number of leave remaining".
Actually i don't know if we can use Countif function when Data are on different sheets.

Here is how I would approach this. Yes you can use the COUNTIF across multiple tabs, but this method may be easier since it will also give you results by the month.

Look at the attachment and you will see on each month (only did Jan and Feb) there is a block added at the end to total up each employee.

Then on the main sheet you just simply take a sum of that one cell across all tabs.

Vmgballer1 Welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.