[Absence Rate Calculator] Absenteeism Rate Calculation

Employee Absence Rate Calculator

Absense Days:
Total Employees
Working Days:
Absense Rate:

Absenteeism Rate Calculation Formula and Explanation:

Are you want to know that how our calculator calculates the absence rate, or you want to know that how is absenteeism calculated rate calculate manually on a calculator? If your answer is YES, then follow the below formula and our explanation.

At first look the formula:

Absence rate=(absense days/(total employees*working days))*100%

Now let’s explain by examples:

Suppose your startup/company has a total of 250 employees and their total absent days 100 and working days is 20. Now, look at how we calculated this.

=(100/(250*20))*100%

=0.02‬*100%

=2


How Do You Calculate Absenteeism in Excel?

You can calculate absenteeism in excel. To calculate the absenteeism rate you need to 3 details:

  • Absence days
  • Total Employees
  • Working Days

Add these details on a2, a3, a4 cells or where you want. Then input the data I mean Absence Days like 100 days and others on b2, b3, b4 cells.

Now type this formula where you want to show the absense rate.

Formula:

=(B2/(B3*B4))*100

Formula Definition:

=(absense days/(total employees*Working days))*100

You can also see this image to better understand.

absenteeism rate calculator

Or you can use our free online calculator see above calculator.

Is this calculator helpful?

Share on: