[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.




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 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: