Page Contents:
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.

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