# How to Calculate Absenteeism Percentage in Excel (2 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In every educational institution and office, itâ€™s a common task to calculate absenteeism percentages for students or employees. It helps to determine who is more absent and who is less absent. If you are searching for ways how to do it then you have come to the right place. We hope this tutorial will show you two easy and useful methods to calculate absenteeism percentage in Excel.

## What Is Absenteeism Percentage?

The percentage of unintentional absence because of sickness or any other causes is called the absenteeism percentage, absence percentage, or absenteeism rate. It shows the ratio between absence days and working days. The basic absenteeism percentage formula is:

• Absenteeism Percentage = (Total Absence Days / Total Working Days)*100%

## How to Calculate Absenteeism Percentage in Excel: 2 Ways

In this section, weâ€™ll demonstrate the two easy methods with sharp steps and vivid illustrations.

### 1. Calculating Individual Person-Based Absenteeism Percentage

In our first method, weâ€™ll show how to calculate the absenteeism percentage for every person. For that, weâ€™ll use a dataset that contains some employeesâ€™ information on working days and absent days.

Steps:

• Insert the following absenteeism formula into Cell F5â€“
`=E5/C5`
• Then just hit the Enter button to get the absenteeism percentage of the first employee.

• Later, use the Fill Handle tool to copy the formula for the other employees.

After a while, you will get all the absenteeism percentages for all the employees.

### 2. Calculating Overall Absenteeism Percentage in Excel

Now weâ€™ll determine the overall monthly and yearly absenteeism percentage for all the employees of a company. It will help to set and maintain an acceptable absenteeism rate for the company.

For this method, we modified the dataset which contains the working days and absent days of every month for the average number of employees.

Steps:

• In Cell F5, type the following formula to get the average absenteeism rate for January-
`=E5/D5`
• Next, press the Enter button for the output.

• To get the other average absenteeism rates for the other months, drag down the Fill Handle icon till the Cell F16.

Here are all the average absenteeism rates for every month.

Now weâ€™ll calculate the absenteeism rates for a year. For that, weâ€™ll need the total working days and total absent days for the year using the SUM function.

• Write the following formula in Cell D17 to get the total working days for the year-
`=SUM(D5:D16)`
• Then hit the Enter button to get the sum.

• Next, to get the total absent days for the year, insert the following formula in Cell E17 â€“
`=SUM(E5:E16)`
• Then press the Enter button to get the sum.

• Finally, to get the average absenteeism percentage for the year, type the following formula in Cell F18â€“
`=E17/D17`
• After that, hit the Enter button to finish.

## Absenteeism Percentage Calculator in Excel

In our workbook, you will get an absenteeism Excel template that you can use as an absenteeism percentage calculator.

You can download the free Excel workbook from here and practice independently.

## Conclusion

Thatâ€™s all for the article. I hope the procedures described above will be good enough to calculate the absenteeism percentage in Excel. Feel free to ask any question in the comment section and please give me feedback.

## Related Articles

<< Go Back to Percentage Formula Examples |Â Calculating PercentagesÂ | Calculate in Excel | Learn Excel

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF