High pressure is set to make way for low pressure by the end of the weekend, according to Met Office forecasts