Excel for a fleet: which vehicle is free
A fleet board is one row per vehicle. The status you type says whether it is free, out, or in the workshop. The next date you type says when a service or a document comes due. COUNTIFS counts the rows whose status is available. A service history, one line per oil change, is a log. This sheet is the board you use when someone asks for a vehicle today. You do not rebuild that history here. The guide below is the board. Elyx writes the due flag from the dates you entered. You still decide which vehicle goes out. The trial lasts 7 days, with no card.
Frequently asked questions
What is one row on the fleet board?
One vehicle: its identifier, the status you typed, the driver, and the next date you are watching. The due flag compares that date with today.
Where do past services go?
On a log, one line per service. The board keeps the next date only. Mixing every past service onto the board gives you several rows for one vehicle.
Does the sheet know a legal inspection interval?
No. You type the next date. The formula only compares that date with today, or with a window you typed in a cell.