Waitlist Conversion Rate

Excel Formulas › Childcare & Daycare

All versions

The waitlist conversion rate — families who enroll over those offered a spot — shows how well your waitlist turns into filled slots, and how many offers it takes to fill openings.

Quick formula: conversion from enrolled and offered:

=enrolled / offered

Families who enrolled over families offered a spot. 18 of 30 offers is 60% conversion.

The example

18 enrolled of 30 offered.

	A	B
1	Item	Value
2	18 / 30	—
3	Conversion	→ 60%

The formula

The formula:

=enrolled / offered // enrolled ÷ offered

How it works

How it works:

Divide families enrolled by families offered a spot for the conversion rate.
Flip it to plan: offers needed = openings ÷ conversion rate.
A low rate means a stale waitlist or a slow offer process — refresh and follow up faster.
Track by age room — infant demand often converts higher than preschool.

Conversion tells you how deep to dial the waitlist. If only 60% of offers convert, filling 6 openings means extending about 10 offers — openings ÷ conversion. Centers that treat the waitlist as a static list under-offer and sit on empty (revenue-losing) slots. Track conversion, then make enough offers to fill, while keeping the list fresh so the families you reach are still looking.

Try it: interactive demo

Live demo

Enrolled, offered, openings to fill.

Enrolled

Offered

Openings

Conversion · Offers needed

Variations

Offers needed to fill

Plan the outreach:

=ROUNDUP(openings / conversion_rate, 0)

Decline rate

The complement:

=1 - enrolled/offered

By age room

Segment demand:

=COUNTIFS(room,"Infant",status,"Enrolled") / COUNTIF(room,"Infant")

Pitfalls & errors

Enrolled vs offered. Conversion is enrolled ÷ offered, not waitlist size.

Fresh list. Stale waitlists convert poorly — keep it current.

Zero offers. No offers gives #DIV/0!.

Practice workbook

📊

Download the free Waitlist Conversion Rate practice workbook

A waitlist sheet with the offers-needed, decline, and by-room variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate waitlist conversion in Excel?

Enrolled over offered: =enrolled / offered. 18 of 30 offers is 60%.

How many offers do I need to fill openings?

=ROUNDUP(openings / conversion_rate, 0). At 60%, filling 6 spots takes ~10 offers.

Why is my conversion low?

Often a stale waitlist or slow follow-up — families have already found care. Keep the list fresh and respond fast.

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