Myelesson: How To Maintain Attendance In Excel

How To Maintain Attendance In Excel

In this article you will learn how to maintain attendance in Excel for your school, office ,etc. In attendance the following aspects are of importance

· Name of Attendee
· Date
· Present status
· Absent status
· Leave status
· Half day status
· Week off status

In this example I have used the following legends

· P = Present
· A = Absent
· L = Leave
· HD = Half Day
· Off = Week off or Holiday

In this example the following formulas have been used

· Counta Formula
· Countif Formula

To create attendance we have to first enter the names of the attendees in a column C as shown in the example

and the dates would be entered in Row 3 starting from column D as shown in the example

Then we can start entering the appropriate attendance status against the names as shown in the example

Now the important part starts

1. Calculating the total days in the given date range

To do this we would use the Counta Formula , It will simply count the number of cells in the range that are not empty .

2. Calculating the Present days

To calculate the present days we would use the Countif Formula . Here we have the option to choose whether we want to just count his present days like in school attendance or do we want to count the week off days also like in office attendance so that we arrive at a true count of present days like shown in the example below (Office attendance)