When a service is due at a set distance or a set number of months, whichever comes first, you need to compute both limits and act on the earlier one. The distance limit is the last service km plus the interval. The date limit is the last service date plus the months. Convert the remaining kilometres into days using your own daily distance, then take the smaller of the two.
Why does it matter for low-mileage users?
If you cover a few kilometres a day, you will reach the date limit long before the kilometre limit, and a sheet that only watches the odometer will happily say you are fine. Occasional drivers, second vehicles and a parent's scooter are the usual victims. Both limits need watching, so a formula that checks both is worth the minute it takes to set up.
Time limits are often there because oil, other fluids and rubber age even when a vehicle barely moves. Your manual states its own reasons and its own limits, so take both numbers from it.
What does the sheet layout look like?
Put labels in column A and values in column B. The interval here is made up; take yours from the manual. Say the last service was on 10 January 2026 at 20,000 km, the interval is 5,000 km or 6 months, and today is 20 May with the odometer at 21,800.
| Cell | What it holds | Formula or value |
|---|---|---|
| B1 | Last service date | 10-Jan-2026 |
| B2 | Last service km | 20000 |
| B3 | Interval km | 5000 |
| B4 | Interval months | 6 |
| B5 | Current odometer | 21800 |
| B6 | Due km | =B2+B3 |
| B7 | Due date | =EDATE(B1,B4) |
| B8 | Km left | =B6-B5 |
| B9 | Days left by date | =B7-TODAY() |
| B10 | Average km per day | =IFERROR((B5-B2)/(TODAY()-B1),0) |
| B11 | Days left by km | =IFERROR(B8/B10,"") |
| B12 | Which comes first | =IF(B9<B11,"Date","Km") |
What do the numbers say in the example?
Due km is 25,000, and km left is 3,200. Between 10 January and 20 May there are 130 days, and the bike covered 1,800 km, so the average is about 13.8 km a day. At that pace 3,200 km takes about 231 days. The due date is 10 July, which is 51 days away. The date comes first by a wide margin, so the service should be booked for the next few weeks even though the odometer is nowhere near the limit.
How do you get a reminder?
- Add =MIN(B9,B11) as the days left to the sooner limit.
- Add a status: =IF(MIN(B9,B11)<=21,"Book now","OK").
- Use conditional formatting to turn the cell red when it says Book now.
- Add a calendar reminder for the due date as a backstop, because a sheet you never open does not remind anyone.
What should you do after each service?
- Change B1 to the new service date and B2 to the new odometer reading.
- Check the interval in the manual, as the first services often follow a different schedule from later ones.
- Keep the job card photo with the date.
- Adjust the average if your usage has changed.
Does the manual or the dealer decide?
The owner's manual and the service booklet set the intervals, and a dealer may explain how they apply to you. If anything is unclear, such as what happens when you pass the limit by a few days, ask them directly. The formulas only tell you where you stand.
Where does SpendixAI fit?
The due-date logic belongs in your sheet. When the sheet stops being enough for the money side, SpendixAI can keep your service payments and job card photos together and show yearly vehicle spend in reports.
A last check
- Both limits are in the sheet, and the sooner one is highlighted.
- The odometer is updated at least monthly.
- A calendar reminder exists for the date limit.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
