Hello everybody, can anyone tell me the formula to calculate the attrition rate of the company thanks in advance Regards, Nipuna
From India, Delhi
Acknowledge(0)
Amend(0)

Hi Nipuna,

The attrition rate is calculated as the number of resignations in a month divided by the available manpower, multiplied by 100. For instance, if at the beginning of the previous month the manpower count was 80, and during that month 5 employees resigned and 10 new employees joined, then on the last day of the month, the manpower count would be 80 - 5 + 10 = 85. Therefore, the attrition rate would be calculated as 5/85 * 100.

I hope this resolves the query.

Regards,
Amit Seth

From India, Ahmadabad
Acknowledge(0)
Amend(0)

Dear Nipuna Please fiond enlosed an exell formant fro calculating attrition. Regards Govil Nanda
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls attritionrate_revisedformula_1__742.xls (19.0 KB, 309 views)

Acknowledge(0)
Amend(0)

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.