Fleet utilization is the share of available vehicle-time (or capacity) actually in use — active days over available days. It reveals idle assets and whether the fleet is the right size.
The example
520 active of 600 vehicle-days.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Active days | 520 |
| 3 | ÷ (20×30) | → 86.7% |
The formula
The formula:
How it works
How it works:
- Available vehicle-days = number of vehicles × days in the period.
- Active days total the days vehicles were actually in service.
- Divide for utilization — low means idle assets, very high means no slack for maintenance.
- Track per vehicle with
SUMIFto spot underused units to reassign or sell.
Utilization right-sizes the fleet. If utilization sits at 60%, you may be carrying (and paying insurance, depreciation, and registration on) more vehicles than you need. Conversely, near-100% leaves no buffer for breakdowns. Pairing utilization with cost per mile shows whether to cut, keep, or add units.
Try it: interactive demo
Active days, vehicles, days in period.
Variations
Available vehicle-days
Capacity:
Per vehicle
One unit:
Idle days
Unused capacity:
Pitfalls & errors
Vehicle-days, not vehicles. The base is vehicles × days.
Leave maintenance slack. 100% utilization means no time for service.
Zero capacity. No vehicles or days gives #DIV/0!.
Practice workbook
Frequently asked questions
How do I calculate fleet utilization in Excel?
What does low utilization mean?
Is 100% utilization good?
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