HoW tO mAkE aTtEnDaNcE ShEeT iN tHe ExCeL

If you are working as an accountant or a clerk you have to make monthly attendance sheet of the employees/staff/students. Monthly attendance sheet is mainly used for calculating the salary paid to the employees. Because in this we check the total working days and the employee present/absent in that particular month.

• Given below is the weekly attendance sheet of the employees. We have to fill /mark the attendance manually. It consume some time but after that with the help of formula we calculate the no. of working /present or absent days of the employee.

• First step is to calculate the working days. Total working days of that particular company/office/ school or any other institution. So, we apply =COUNTA(Range of day of the particular employee).

• As you can see below the formula applied. By this formula we know the total number of working days.

• After typing formula press enter and you see the number of working days and simply drag the column up to where the list of the employees. You can see the formula in the formula bar.

• Now we calculate the number of days the employees are present =COUNTIF(Select Range of days , " P") . then press enter. You can see the days on which the employee is present . For calculating the number of days the employee absent we apply the similar formula as the formula applied in the calculation of number of present days. =COUNTIF(Select Range of days , " A"). Then press enter and drag the column till the list of employees.

• And to calculate the total amount paid we multiply the no. of present days and daily wages. The multiply formula which I mentioned in the previous blog. 

• Press enter and the total amount paid to the employee will be shown then drag the column.

In above picture you will see how the whole attendance should be maintained. By this particular formula you can work anywhere as a clerk or accountant.