# Absenteeism Rate Calculator

Absenteeism rate refers to how many average days an employer has absent in a company/factory/industry. Calculate absenteeism by the following absence calculator.

## Employee Absenteeism Rate Calculator

Enter Absense days, Total employees, Working days and hit anywhere

### 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 absence rate formula and our explanation.

At first look the absenteeism percentage formula:

Absence rate= (absence days ÷ (total employees x working days)) x 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 x 20)) x 100%

=0.02‬ x 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

Absenteeism rate formula Definition:

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

You can also see this image to better understand.