ƒx

Excel Retention Rate Formula

hr Difficulty:

One-Click Copy

((End_Count - New_Hires) / Start_Count) * 100

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Calculates the percentage of employees who remained with the company over a specific time period.

Measure your ability to keep talent.

Calculate Retention Rate

Measure your ability to keep talent.

Inputs

End_Count Number of employees at the end of the period.
New_Hires Number of employees hired during the period.
Start_Count Number of employees at the start of the period.

Practical Example

((105 - 10) / 100) * 100

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.