Dear All, Can anyone please guide me on how to calculate attrition rate. What is the standard formula used for attrition analysis.
From India, Kolkata
Training & Development
Deputy Manager - Hr
Hr Generalist
Executive - Hr
Legal And Payroll Manager
+4 Others


hi Standard formula is no of left employees/total strength*100 will give you the attrtion percentage.

Rajendra Bhavsar

Hi Attached pl. find herewith format for calculating attrition rate. Regards Rajendra Bhavsar Manager (P&A) Afcons Infrastructure Ltd. CMRL Project, Chennai 8754543347
From India, Mumbai

Attached Files (Download Requires Membership)
File Type: xls ATTRITION___REPORT.xls (31.0 KB, 6556 views)

Hi, As per my knowledge the attrition formula shall be : No. of employees left/Average no. of employees*100 Regards
From India

Hello All,
for attrition rate,formula is No. of left employees/average of (total employees at the starting of month & total no. of employee at the ending of month)* 100 and for employee turnover it is left employee/total employee in end of month*100 (in case if we calculate it on month basis)

From India, Pune

hi suhani, you can find number of formats and their clarifications from this booklet. its assured you will get fantastic knowledge out of this.
From India, Ahmedabad
Palaniswamy Ram

Dear Suhani,
The attrition formula is A/(B+C-A)*100
A = Nof of employees left in the Month
B = No.of employees on 01st DAY of the month
C= Newly joined during the month
Nof of employees left in the Month/ (No.of employees on 01st of the month + addition during the month - left employees)*100
If it is for year, Nof of employees left during the year/ (No.of employees on 01st January+ addition during the year upto 31st December - left employees during the year)*100

From India, Namakkal
Dear Members,
Can you please guide me whether we should take the employees present for the month or should we take the actual number of positions for calculating the attrition every month.
For example if a department has 10 positions, then should the opening balance be 10 for every month or should the closing balance of the previous month be the opening balance of the next month.
K Lakshme devi

From India, Pondicherry

Suhanidutta, You can use attached document to calculate attrition for the desired period. Formula = Relieved members / Average( Opening headcount & Closing headcount) Thanks
From India, Bangalore

Attached Files (Download Requires Membership)
File Type: xls Attrition-Analysis.xls (19.0 KB, 3043 views)


You can do it 2 ways.In my view attrition is 2 types,monthly attrition & annual attirtion.However,you will be always more interested for annual attrition.For that you may annualize each months actual attrition to reach at the avg. attrition at the end of the year.This will give you the correct picture & through out the year,you can have an eye on the end figure of Annual attrition.Its just like run rate per over In Cricket so that at end of 50 ovrs how much will be your total score.
One formula we may use is =
(Total employees resigned/avg. head count)*(12/no. of months you have completed in that financial year)*100
To explain,suppose after end of 4 months,total resignation no. is 200.Total head count in these 4 months being,3000,3050,3075,3065.
So the annualized attrition will be (200/3047)*(1/42)*100=19%.
That means your attrition after 4 months is & after 12 months will be 19 %..Next month,you can check considering 5 months & find if it has increased or decreased.

From India, Chennai

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server