Unsurprisingly, the big smoke came in as the most expensive, with a weekend break in London averaging £1,331 – more than double the price of a trip to Sheffield. It was also the most expensive destination for dinner, which was estimated to cost around £71 for two.

In an unforeseen result, London came in as the cheapest destination for lunch, which was priced at £18 for two. Additionally, the capital was overtaken by Edinburgh (likely due to the annual festival) as the most expensive place for an overnight stay, with a whopping average cost of £232 for four-star accommodation, where London’s equivalent was £181/night. Cambridge came in second, with an average night stay of £199.

Chester will cost you most for lunch, setting you back £25 for two, but was the third best value for dinner, at £55.

If you’re after an affordable day trip, Oxford came out as having the cheapest tourist attractions in the UK – their four top ones all being free as charge.

So, if a visit to the Notting Hill Carnival isn’t for you, and you’re looking to guzzle the last of the summer wine, devour the latest suburban noir or just kick-back and relax, take a look at the list and see what might suit. We've even taken the liberty of researching some lovely hotels that are still available if you decide to rush of on a last-minute escape. You can thank us later.

The most and least affordable UK cities to visit on bank holiday weekend revealed. (Plus five perfect getaways you can still book)