Dates and IFs Query

Hi,

Thanks for the speedy response. This has worked for updating one of the red cells I had a problem with but not the rest. It worked for cell L3, but not for Q2..

Its when the date starts during the middle of any particular week is when the problem occurs.