When will Spain's heatwave end?

Like much of western Europe, Spain has been suffering from an intense heatwave over the past days, with temperatures climbing over 40C. When can we expect a drop in temperatures?