Bed occupancy is occupied bed-days over available bed-days — the core measure of hospital capacity utilization. Patient-days divided by available bed-days, as a percentage.
The example
2,400 patient-days, 100 beds, 30 days.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Patient-days | 2400 |
| 3 | ÷ (100×30) | → 80% |
The formula
The formula:
How it works
How it works:
- Patient-days total the nights all patients occupied a bed in the period.
- Available bed-days = number of beds × days in the period.
- Divide for the occupancy rate — how full the hospital ran, on average.
- Very high occupancy strains capacity; very low wastes it — managers target a healthy band (often ~85%).
Average length of stay (ALOS) pairs naturally with occupancy: =patient_days / discharges. Together they explain capacity — a unit can be at 90% occupancy because of high admissions or long stays, and the response differs. Tracking both turns a single utilization number into something you can act on.
Try it: interactive demo
Patient-days, beds, days in period.
Variations
Available bed-days
Capacity:
Average length of stay
ALOS:
Beds needed for a target
Plan capacity:
Pitfalls & errors
Bed-days, not beds. The denominator is beds × days, not just bed count.
Count staffed beds. Use available (staffed) beds, not licensed beds, for real utilization.
Same period. Patient-days and days-in-period must align.
Practice workbook
Frequently asked questions
How do I calculate hospital bed occupancy in Excel?
What is average length of stay?
Should I use licensed or staffed beds?
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