Turnover rate in a project I have to calculate the monthly turnover rate of my team. The formula I am using is the same as described in (< !enter image description here The point is in the beginning of the month I had no employees and in the end of this month I have no employees. We had 5 people that have joined the team and the same 5 people that have left the team in the same month. Replacing this data into the equation I have: Monthly turnover rate = [ 5 / ( (0 + 0) / 2 ) ] * 100 However, division by 0 does not exist. How should I report this turnover rate? Thanks,

At a high level the max turnover rate is 100% if everyone leaves. It can exceed 100% if you hire new people during the month and they are also gone by the end of the month.

The formula you are using is good for typical (low) turnover rates, not for extreme situations like this. In your example simply taking the headcount at the beginning of the month and end of the month and averaging that won't work. You should do a more granular average - by number of weeks or even days.

Let us say the five employees stayed for 12 days each. Your average employees during the month would be = 5x12/30 = 2

Monthly turnover rate = (5/2) x 100 = 250%