Free TimeTrex resource
Measure retention for a defined hire cohort at the same service milestone. Keep not-yet-eligible hires out of the rate and make your assumptions visible.
Use one intake cohort and one service milestone. Example counts are invented; reconcile your records before entering them.
Eligible hires E = total cohort hires H − not-yet-eligible hires P. Retained hires R = E − eligible departures L. Retention = R / E × 100. Cohort early-departure share = L / E × 100. These two percentages sum to 100% only because they use the same eligible group and mutually exclusive outcomes.
With 100 hires, 20 not yet eligible and 12 eligible departures, E = 80 and R = 68. Retention is 85.00% and early-departure share is 15.00%. A 90% scenario needs round upward(80 × 0.90) = 72 retained outcomes, a gap of 4. This comparison cannot change historical departures and does not predict another cohort's results.
At an observation date of October 23, 2026 and a 90-day elapsed milestone, the latest eligible start date is July 25, 2026. Date calculations use calendar days, including weekends and holidays; time zones and daylight-saving hours do not change the date subtraction.
The start date is day 0. A person whose start date plus D days equals the observation date is eligible. For this worksheet, a last employed date equal to the milestone date counts as retained; a last employed date before it counts as left. If your system records the first non-employed date, reconcile it to the last employed date first.
If no hires are eligible, the rate, required outcomes and gap show N/A. The worksheet does not report a misleading zero-percent retention rate. It also shows how many hires are excluded. It does not estimate a survival curve or predict immature hires' outcomes.
A milestone is an elapsed-day count, not a calendar-month anniversary: 365 days and one year may differ around leap years. Verify date conventions against your records.
Required retained outcomes = round upward(E × target / 100). Target outcome gap = max(0, required − actual retained). The chosen target accepts zero through 100 with up to two decimal places. Integer arithmetic is used for the target comparison, so exact whole outcomes do not accidentally round up because of floating-point noise.
Counts must be whole numbers from zero through 1,000,000. Not-yet-eligible hires cannot exceed total hires; eligible departures cannot exceed eligible hires. Milestones must be 1 through 3,650 days. Observation dates must be 2000 through 2100. Rates display two decimals; CSV retains calculation precision.
A cohort result describes recorded outcomes; it does not establish why people left, whether onboarding caused an outcome, or whether an individual is suitable for employment. Small cohorts can move sharply when one person leaves. Consider role, location, contract length and record quality before comparing results.
This independently defined cohort worksheet is separate from whole-workforce turnover based on average headcount or a measure of new-hire departures as a share of all departures. Do not substitute one denominator for another or subtract an unrelated turnover percentage from 100.
The calculator runs in your browser, stores no inputs and does not connect to employee records. It provides aggregate planning arithmetic, with no employment, legal or compliance determination.
Copy this CSV if your browser blocks the download.
Primary sources checked October 23, 2026. They provide context for retention and an explicit early-service horizon. The eligibility rules and formulas above define this independent worksheet; no benchmark or legal threshold is imported.
Disclaimer: This voluntary workforce planning worksheet uses user-reconciled aggregate hire-cohort counts and calendar-day milestones. It cannot verify eligibility, continuous service, separation dates, rehires, transfers or leave treatment. Outcomes refer to each eligible hire at their own milestone, not necessarily current employment. Its date cutoff is a calendar aid, not a legal service or probation rule. The chosen target is a hypothetical comparison, not an industry benchmark, forecast, assessment of an individual or recommendation for an employment decision. Small samples and inconsistent records can distort results. Verify all inputs, results and assumptions against appropriate records and obtain qualified advice before relying on them. To the fullest extent permitted by applicable law, this resource is provided “as is” without warranties of accuracy, completeness or fitness for a particular purpose, and TimeTrex and its affiliates disclaim liability for losses, damages, costs or claims arising from its use, inability to use, or reliance on it, including errors or omissions. Nothing in this disclaimer excludes or limits liability or rights that cannot lawfully be excluded or limited.
Trusted By
Join our ever-growing community of satisfied customers today and experience the unparalleled benefits of TimeTrex.
Strength In Numbers
Time To Clock-In
Experience the Ultimate Workforce Solution and Revolutionize Your Business Today
Saving businesses time and money through better workforce management since 2003.
Copyright © 2026 TimeTrex. All Rights Reserved.