How to create Attendance Tracking Formula?

Basic attendance tracking: To track the records and calculate the overall attendance of a student, here’s what to do:

As you can observe in the image above, we have shown few roll numbers and their attendance of one week i.e. from Monday to Friday.

Now to calculate the no. of days a particular student was present on, or absent on, here’s what we do:

Step 1: Input the formula =COUNTIF(

As we are going to count the no. of days the particular student was present, we will use the COUNTIF Function for the same.

The following function is as follows:

=COUNTIF(

Step 2: Input the required values in the formula

The following formula requires range as well as criteria.

The range will be the no. of days i.e. B3:F3.

Then we will come to the point of criteria. As we have written P below the days the particular student was present, so our criteria will be the same. But the thing is, we cannot just select any cell which has P in it.

Instead we will directly write P but in quotations marks, by this we are adding particular specifications to the formula.

So, it has to be written as:

“P”

Step 3: Cross- check the formula and proceed

By now, our overall formula becomes as follows:

=COUNTIF(B3:F3,”P”)

Now all we have to do is press enter and BAAAAMMMM! The answer is 4. This means that the Roll No. 321 was present on 4 days out of 5.

To find out the no. of days the rest of the students were present on, simply drag down the formula till it’s requires just like it is shown in the image above.

Now, we will count the no. of days the students were absent on.

Step 4: Input the formula =COUNTIF( again

We will input the COUNTIF Function which is as follows:

=COUNTIF(

Step 5: Input the required values in the formula

The following formula will require a range as well as a criteria to follow.

We will select the range, like we did before, which makes it B3:F3.

Then in the case of criteria, we will leave the quotation marks empty. This is because, the no. of days the students were absent on, nothing was written instead the day was left blank.

Step 6: Cross- check the formula and proceed

So, after inputting the criteria, we will close the COUNTIF Function. By now, our overall formula becomes as follows:

=COUNTIF(B3:F3,””)

Now all you have to do is press enter and drag down the formula till it’s required.

There you go, the basic attendance tracking formula. This type of formula can be used in corporations to keep a check on the employees to make sure that they are not exceeding their paid leaves or permitted leaves.

It’s easy, isn’t it?

How to get same date next month using EDATE function?