Forum Discussion

Vinod_Sir's avatar
Vinod_Sir
Copper Contributor
Apr 25, 2024
Solved

Attrition Rate calculation in Excel

To calculate Attrition in every MNC company they use formulas as below ( sharing own industry experience across wide range of community)

MTD - Total Nos of attrition/ Total Nos of Head count

YTD - total attrition from starting month to end month / average HC of starting month to end month 

 

Don't forget in headcount calculation we will also consider headcount attrited as a total calculation 

1 Reply

Resources