Attendence list in Excel

In this tutorial we will learn attendence list using Excel.
We will use Countif function in this tutorial.
1.Example:
   x means present.
   Blank cells showing absent.

   

2.Example:We can also count absent days by using Countif        function as shown in below image.

We can see in following image that employee ID 706 have only 1 absent.Inverted commas "" in formula count blank cells