How to Calculate Absenteeism Percentage in Excel: 2 Easy Methods

Method 1 – Calculating Individual Person-Based Absenteeism Percentage

Steps:

  • Insert the following absenteeism formula into Cell F5
=E5/C5
  • Hit the Enter button to get the absenteeism percentage of the first employee.

Formula to Calculate Individual Person-Based Absenteeism Percentage

  • Use the Fill Handle tool to copy the formula for the other employees.

Use Fill Handle Tool to Calculate Individual Person-Based Absenteeism Percentage

You will get all the absenteeism percentages for all the employees.


Method 2 – Calculating Overall Absenteeism Percentage in Excel

Steps:

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

Insert Formula to Calculate Overall Absenteeism Percentage in Excel

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

Drag Down Fill Handle Icon to Get Overall Absenteeism Percentage in Excel

All the average absenteeism rates for every month.

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)
  • Hit the Enter button to get the sum.

  • Get the total absent days for the year, insert the following formula in Cell E17
=SUM(E5:E16)
  • Press the Enter button to get the sum.

  • Get the average absenteeism percentage for the year, type the following formula in Cell F18
=E17/D17
  • Hit the Enter button to finish.


Download Practice Workbook

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


Related Articles


<< Go Back to Percentage Formula ExamplesCalculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo