Attrition Rate calculation in Excel

[Vinod_Sir]

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 

[#2 · Accepted solution]

@Vinod_Sir 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.