FDibbins,

Cheers the Array formula works a treat, I will spend some time and break it down so I can understand it better for future use

As for the week num, im so used to doing it the other way due to using it with SUMIF and COUNTIF's lol