Monday is expected to be the best weather of the long weekend, the Met Office said.