You only find out two bookings clash when the second person turns up at the door — or when a van is promised to two jobs on the same morning. By then, someone has to be let down, and a spreadsheet that looked fine row by row is no help at all. That is why you need a booking overlap checker before you confirm anything: paste the list, let the tool group it by item, and see every clash with the dates the two bookings share.
Use a comma or a tab between the three parts. Dates must match the format you pick below.
How to use the booking overlap checker in three passes
Start by pasting your bookings into the box above, one per line, in the form item, start date, end date — for example, Room A, 2026-11-07, 2026-11-09. Commas or tabs both work, so you can copy straight from a spreadsheet, and the date format box lets you match the way your own dates are written, whether that is 2026-11-07, 07/11/2026 or 07-11-2026.
Press Check for overlaps and the tool first groups everything by item, so Room A is only ever compared with Room A and Van 1 is only ever compared with Van 1. Inside each group it reads the start and end of every booking, applies the end-date rule you picked, and compares each pair of ranges. Any pair that shares at least one day is listed as a conflict pair, with the overlap start, the overlap end and the number of shared days, so you can see at a glance which two bookings are fighting over which dates.
Below that, every row you pasted gets its own verdict: OK if it clashes with nothing, or Conflict if it shares a date with another booking for the same item. A final table counts the conflicts per item, and the clean list at the bottom holds only the bookings with no clash, ready to copy back into your planner or your booking sheet.
The end-date rule: inclusive or exclusive?
The trickiest part of any overlap check is the end date, because it means two different things in different places. In a hotel or a hire booking, the end date is usually the check-out day: a guest who leaves on 9 November is not using the room on the 9th, so a new guest can arrive that same day. That is the exclusive rule, and it is the one the tool uses by default.
In other lists, the end date is the last day something is actually booked — a member of staff covering a shift until 9 November is still on cover on the 9th, and a second person booked for that same day would be a real clash. That is the inclusive rule. Pick the one that matches how your list is written before you press Check for overlaps, because the same two rows can be fine under one rule and a conflict under the other.
Take Room A booked 7–9 November and again 9–11 November. Under the exclusive rule there is no clash: the first booking ends as the second begins. Switch to inclusive and the two bookings share 9 November, so the tool flags them as a pair with one shared day. If you are not sure which rule your list uses, check what happened on the last handover day — if the item was free for the next booking, your rule is exclusive.
Same item, same dates: what counts as a clash
The checker only compares bookings for the same item, the same room, van or staff member. Two bookings clash when their date ranges share at least one day, under the end-date rule you picked.
Worked example: two Room A bookings clash on 10 November
Press Load example and the tool fills in five bookings: three for Room A and two for Van 1. Room A is booked 7–9 November, then 9–11 November, then 10–13 November, while Van 1 is booked 7–8 November and 9–10 November. With the default exclusive rule, the first two Room A bookings sit neatly back to back, so they do not clash at all.
The problem is the third Room A booking. It runs 10–13 November, and the second booking runs 9–11 November, so the two share 10 November — one shared day, shown in the conflict pairs table as an overlap from 10 November to 10 November. Both of those rows are marked Conflict, the other Room A row and the Van 1 rows stay OK, and the per-item table shows Room A with one conflict pair and two conflicting rows, and Van 1 with none.
That one shared day is the whole point of the check. On a list, 9–11 November and 10–13 November both look reasonable on their own, and the clash only shows up when the two ranges are laid over each other. Now switch the end-date rule to inclusive and press Check again: the first two Room A bookings join the list too, because they now share 9 November, and the count rises to two conflict pairs.
What to do with the clean list
Once you have the results, fix the clash before you confirm anything else. Move one of the two bookings, shorten it so it ends before the other starts, or move it to a different item — a different room, a different van, a different member of staff. Then paste the corrected list back in and check it again; a clean run should show no conflict pairs and every row marked OK.
Keep the clean list as your working copy. It holds only the bookings that survived the check, in the same item, start date, end date form you pasted in, so you can drop it straight back into your spreadsheet without retyping the safe rows. If new bookings arrive later, add them to the list and run the check again rather than eyeballing the new rows against the old ones — that is the moment a clash usually slips through.
Related date tools
If your dates need measuring as well as checking, a tool that works out how many days a year your ranges cover does it for you, which is handy when a booking straddles a year end or you need a total for a hire charge. And if a list of dates looks short rather than clashing, the Missing Dates Finder finds the dates that should be in a list but are not, so a gap in a rota or a timesheet does not go unnoticed.
Frequently asked questions
What counts as an overlap?
An overlap is any date — or, with time of day switched on, any minute — that two bookings for the same item both cover. Two bookings that only touch at a boundary, such as one ending on 9 November and the next starting on 9 November under the exclusive rule, do not count, because the first booking has already ended when the second begins.
Does the tool only compare bookings for the same item?
Yes. Bookings are grouped by the item name in the first column, and ranges are only compared inside their own group, so Room A on 10 November and Van 1 on 10 November are never flagged as a clash. Keep item names consistent, because Room A and Room-A are treated as different items.
How does time-of-day handling work?
Tick Include time of day and add a time after each date, such as 2026-11-07 14:00, and the tool compares the ranges to the minute instead of the day, showing the overlap in hours or minutes when it is shorter than a day. A booking ending at 16:00 and another starting at 16:00 do not clash under the exclusive rule, but they share that minute under the inclusive rule.
What does an overlapping booking mean?
It means two bookings for the same item whose date ranges share a day. The checker flags them so you can see the clash and fix it before the bookings go out.
Can I check overlaps for rooms, vans and staff in one list?
Yes. Put the item with each booking, a room, van or staff member, and the checker only compares bookings for the same item, so different items never clash with each other.
Related tools: once the bookings are clash-free, work out what to pack by days and weather for the trip.