The Met Office has issued a red weather warning over the coming days with the peak due on Wednesday and Thursday.