I can offer an in-place calculation, but it can also be converted to a separate report.
Formula for 'Retained' calculation:
=--(SUMPRODUCT(--(C2=$C$2:$C$11);(--(MONTH(B2)+1=MONTH($B$2:$B$11)))+(--(MONTH(B2)-1=MONTH($B$2:$B$11))))>0)
Array formula for 'Retention %' calculation (for employee across all clients):
{=SUM(IF(A2=$A$2:$A$11; IFERROR(1/(COUNTIFS($A$2:$A$11; A2; $C$2:$C$11; $C$2:$C$11;$D$2:$D$11;1));0); 0))/SUMPRODUCT(1/COUNTIF($C$2:$C$11;$C$2:$C$11))}
Edit:
Just add example with an percentage report in a separate table. Same formula, just moved to new area:
{=SUM(IF(G2=$A$2:$A$11; IFERROR(1/(COUNTIFS($A$2:$A$11; G2; $C$2:$C$11; $C$2:$C$11;$D$2:$D$11;1));0); 0))/SUMPRODUCT(1/COUNTIF($C$2:$C$11;$C$2:$C$11))}
CustomerGauge
customergauge.com › the ai first b2b customer intelligence platform › blog index › how to calculate customer retention rate in excel [analysis template]
How to Calculate Customer Retention Rate in Excel [Analysis Template]
March 10, 2023 - To calculate your retention rates using our Excel Sheet, you'll need three datasets.
Livesession
livesession.io › blog › user-retention-rate
Guide to New User Retention Rate & How to Calculate this Metric | LiveSession
Calculate retention rate: divide the number of returning users by the number of starting users, then multiply by 100 to get the retention rate percentage. Formula: (Number of Returning Users / Number of Starting Users) x 100 · Let’s say you’re ...
Videos
03:58
How To Calculate User Retention? - Be App Savvy - YouTube
04:55
Retention guided analysis - YouTube
10:43
Mixpanel: Retention Report Complete Tutorial - YouTube
10:48
Calculate Retention & Churn || Cohort Analysis || Data Analysis ...
05:40
Retention Model in Excel - YouTube
17:50
Customer Retention & Cohort Analysis | How VCs Calculate Customer ...
How do you calculate employee retention rate?
To calculate employee retention rate:
Choose a start date and an end date.
Record how many employees you had at the start.
Subtract the number of new hires between the start and end date from the number of employees you have at the end.
Divide that number by how many employees you had at the start, then multiply by 100.
Employee Retention Rate = ((Employees at End Date − New Hires Between Start and End Date) / Employees at Start Date) x 100
builtin.com
builtin.com › recruiting › employee-retention-rate
Employee Retention Rate: What It Is and How to Calculate It | Built In
What is employee retention rate?
Employee retention rate is the percentage of employees who stay with a company over a specific period of time. It shows how well a company keeps its staff and can reflect employee satisfaction and company stability.
builtin.com
builtin.com › recruiting › employee-retention-rate
Employee Retention Rate: What It Is and How to Calculate It | Built In
What is a good retention rate for employees?
A good employee retention rate varies by industry, but most organizations aim for around 85 to 90 percent or higher. A higher employee retention rate usually means employees are satisfied and the workplace is stable.
builtin.com
builtin.com › recruiting › employee-retention-rate
Employee Retention Rate: What It Is and How to Calculate It | Built In
Zendesk
zendesk.com › blog › calculate-customer-retention-rate
Customer retention rate + formula: A guide for 2025
August 11, 2025 - You can calculate customer retention in Excel by using the customer retention formula.
Indeed
indeed.com › home › hiring resources › calculating retention rate (with 3 examples)
Calculating Retention Rate (With 3 Examples)
Calculation: 40 – 38 = 2 employees left during the quarter. Divide the remaining employees by the total employees at the start: 38 ÷ 40 = 0.95 · Move the decimal two spots to the right to get the percentage.
Built In
builtin.com › recruiting › employee-retention-rate
Employee Retention Rate: What It Is and How to Calculate It | Built In
January 15, 2020 - We’re looking to calculate XYZ Tech’s retention rate for the year of 2025. Period of time = January 1, 2025 to January 1, 2026 · How many people were in your employment on day one of the time period you’ve defined?
Userpilot
userpilot.com › blog › retention-calculation
User Retention Calculation For SaaS
February 28, 2022 - You can calculate rolling retention by dividing the number of users whose last day of activity is on or after Day N by the number of users who first used the app on Day 0. ... Let’s go back to the scenario of having 100 users use your app ...
Quora
quora.com › How-do-you-calculate-30-days-retention-in-a-online-game-cohort-or-not
How to calculate 30 days retention in a online game (cohort or not) - Quora
Answer (1 of 7): First a clarification. What you're calling 2nd day retention is actually D1 (Day 1 retention). When a user first installs/registers that's Day 0. So having said that there are 2 definitions of retention: 1. fixed retention and 2. rolling retention. Fixed Retention: For fixed ...
Lattice
lattice.com › library › how-to-calculate-employee-retention-rate
How to Calculate Employee Retention Rate | Article | Lattice
August 15, 2025 - To calculate the retention rate, divide the total number of employees who stayed with your company through the time period by the headcount you started with on day one. Then, multiply that number by 100 to get your employee retention rate.
Medium
medium.com › permutable-analytics › how-to-calculate-benchmark-day-1-day-7-and-day-30-retention-in-amplitude-analytics-d500a77eae04
How to Calculate & Benchmark Day 1, Day 7, and Day 30 Retention in Amplitude Analytics | by Timothy Daniell | Permutable Analytics | Medium
May 13, 2022 - Day 30 Retention (“D30R”) — 30 days after first use · The important thing is that all measurements are relative to Day 0 for the user, which is their first day regardless of the calendar day.
Braze
braze.com › resources › blog › the top 3 ways to ca...
Calculate User Retention Rate | Braze
October 4, 2024 - Your Day 1 retention rate is 3/10 or 30%. Your Day 2 retention rate is 2/10 or 20%. If five people were to come back 89 days from Monday the 1st (not shown), your Day 90 retention rate would be 5/10 or 50%. Note that the two individuals who ...
Quantum Workplace
quantumworkplace.com › future-of-work › how-to-calculate-employee-retention-rate
How to Calculate Your Employee Retention Rate
May 8, 2025 - Let’s say you had 475 employees on January 1st 2021 and 440 employees on December 31st 2021. To calculate your yearly retention rate, divide 440 by 475 and multiply by 100. ... You have 33 employees on July 1st and 28 employees on September 30th.
Reddit
reddit.com › r/gamedev › how do you calculate the retention rate? (engaged users or installs?)
r/gamedev on Reddit: How do you calculate the retention rate? (Engaged users or installs?)
March 17, 2025 -
Hello. I wonder how other developers calculate their games' retention rates. Do you filter out the players who downloaded the game and did not spend even 2-3 minutes? Or do you directly get the retention rate metrics from Firebase console, Google Analytics, etc?
In my experience, after calculating it based on the people who spent enough time in the game to start their first match (happens between 3 to 10 minutes after entering the game) using the 24-hour rolling window, I realized that I get 2 times higher day-1 retention rate than what it shows on Google Analytics.
Therefore I'm a bit confused. The real purpose of this metric is to see the engagement and I think what I'm doing makes sense. The problem is that I don't want to look like I'm lying to potential investors.
I would love to hear what other developers, publishers, or investors think about it!
Top answer 1 of 4
3
Depends on many factors, but traditionally: 7-day retention: players coming back every day for a week 30-day retention: players coming back every day for a month Week-on-week retention: players returning from one week to the next Month-on-month retention: players returning from one month to the next Usually expressed as a percentage of the playerbase. So for example, a 50% 7-day retention means that 50% of players return daily. You also check this over time. E.g. week-on-week retention rate for the past six months. Edit: Rewrote for less ambiguity. Don't write Reddit posts on your coffee break!
2 of 4
3
Retention is not supposed to be based on any segmentation / user dimension. It should take into account any and all users that initiated a session in a selected time period (cohort) regardless of what feature they engaged with. Additionally, you're masking deeper problems by your approach within the product if a major chunk of your player base churns before engaging with the core loop at least twice. You'd be setting up yourself for failure if you advertise d(x) rates to investors that are double the benchmark of the genre. You can check game analytics benchmark reports that was released recently here: https://www.gameanalytics.com/reports/2025-mobile-gaming-benchmarks
Quora
quora.com › How-can-you-calculate-a-retention-rate-in-Excel
How to calculate a retention rate in Excel - Quora
Answer: Using the Jeff Haden formula: Customer Retention Rate = ((CE-CN)/CS)) X 100 CE = number of customers at end of period CN = number of new customers acquired during period CS = number of customers at start of period
The Bricks
thebricks.com › resources › guide-how-to-calculate-retention-rate-in-excel
How to Calculate Retention Rate in Excel
The formula for calculating retention rate is straightforward: Retention Rate = ((Number of customers at the end of the period - Number of new customers during the period) / Number of customers at the start of the period) * 100 · Now, let’s ...
Harmonyhr
harmonyhr.org › blog › employee-retention-rate-calculator.html
Free Employee Retention Rate Calculator & Excel Template (2025) | Harmony HR
Calculate your employee retention rate in 30 seconds with a free calculator, download a retention rate Excel template, compare your % to 2025 benchmarks by company size and industry, and deploy 25 proven retention strategies with templates in HarmonyHR.
Calculator Academy
calculator.academy › home › retention rate calculator
Retention Rate Calculator - Calculator Academy
July 21, 2023 - Enter the number of employees that stayed during the period and the total number of employees at the start of the period into the Retention Rate Calculator. The calculator will evaluate the Retention Rate.
CleverTap
clevertap.com › blog › retention-rate
Customer Retention Rate Calculator + How to Calculate & Improve Retention
June 30, 2025 - Customer retention rate (CRR) is a core metric that reflects your ability to build long-term customer relationships. It directly impacts profitability, customer lifetime value (CLV), and sustainable growth. This guide breaks down what CRR is, how to calculate it, and includes a free calculator to help you measure it instantly.
Wall Street Prep
wallstreetprep.com › home › retention rate
Retention Rate | Formula + Calculator
September 18, 2024 - The formula to calculate the retention rate is equal to the difference between the number of customers at the end of the period and new customers, divided by the number of customers at the beginning of the period.
Plotline
plotline.so › blog › retention-rates-mobile-apps-by-industry
Retention Rates for Mobile Apps by Industry
30-Day Retention Rate = (Number of users active on Day 30 / Number of users who installed on Day 0) × 100 ... The decision on whether you should calculate retention rates on a 30/60/90-day basis depends on your product's natural frequency.