Retention Rate and Tenure Rate for employees for current year
I am needing help. I want to create a dashboard to see the current years tenure rate and retention rate by tracking month to month.
I have a column for retention status (active vs terminated rate), active status count. Termination month, termination year, termination date, hire date.
I have a formula for total employee count, terminated employee count and current employee count for the year.
I need a formula to help me calculate retention rate and tenure rate please. If I have to add more columns I will do so. If you have created a sheet with this information please help me out. Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!