Rebooking rate is the share of clients who book their next appointment before leaving. It’s the single best predictor of retention — a rebooked client is a returning client.
The example
38 rebooked of 50 seen.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 38 / 50 | — |
| 3 | Rebooking | → 76% |
The formula
The formula:
How it works
How it works:
- Count clients who booked their next visit before leaving —
COUNTIF(rebooked, "Yes"). - Divide by total clients served for the rate.
- Benchmark: many salons target 70%+ pre-booking for healthy retention.
- Track by stylist — rebooking is a coachable, individual habit.
Rebooking is retention you can see at the chair. Unlike retention (which you only learn months later when a client does or doesn’t return), rebooking is measurable today — did they book the next appointment or not? Because it’s a habit each stylist controls, tracking it per stylist with COUNTIFS turns a fuzzy “build your book” goal into a weekly number to coach.
Try it: interactive demo
Rebooked and total clients.
Variations
Count rebooked
From a log:
By stylist
Coach individually:
New vs returning
Split the rate:
Pitfalls & errors
Before leaving. Count rebooks made at checkout, not later phone bookings, for the habit metric.
Consistent flag. One spelling of "Yes" so COUNTIF matches.
Zero clients. A no-traffic day gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate rebooking rate in Excel?
What's a good rebooking rate?
How do I track it by stylist?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class