The Met Office has issued a yellow weather alert for parts of the UK on Friday and Sunday