Thank you both for the help guys, I got sorted in the end although I used a slightly different method which I'll repost for reference. I typed my date in the first cell, highlighted every other cell I wanted to populate and then

Home tab | Fill | Series | select 'Date' and a step value of 7 then OK.

Thanks again for the info and support folks.