Boarding bills by night (often counting check-in and check-out days by policy), plus daycare days, add-ons, and a multi-pet discount. Date math and a few add-ons build the invoice.
The example
In 6/19, out 6/23, $45/night.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 4 nights × 45 | $180 |
| 3 | + add-ons | → invoice |
The formula
The formula:
How it works
How it works:
- Nights = checkout − check-in (adjust +1 if your policy charges the check-out day).
- Multiply by the nightly rate for the base boarding charge.
- Add add-ons (baths, meds, extra play) and any daycare days.
- Apply a multi-pet discount:
subtotal × (1 − discount).
Decide your night-counting rule and bake it into the formula. Some kennels charge by nights stayed (checkout − check-in); others charge the check-out day if the pet leaves after a cutoff time. Pick one, encode it once (add +1 or an IF on pickup time), and every invoice is consistent — no front-desk arguments. Add-ons and the multi-pet discount then layer cleanly on top of a correct base.
Try it: interactive demo
Check-in, check-out, nightly rate, add-ons.
Variations
Charge checkout day
Policy +1:
Multi-pet discount
Off the subtotal:
With daycare days
Add day visits:
Pitfalls & errors
Night-count policy. Decide whether the check-out day is charged.
Real dates. Check-in/out must be date values.
Discount order. Apply multi-pet discount to the subtotal, after add-ons or before — be consistent.
Practice workbook
Frequently asked questions
How do I bill boarding by night in Excel?
How do I add a multi-pet discount?
How do I include daycare?
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