I think this is simple lets walk it out do you know how to copy?  if yes then simply date = date + 7.  now comes the tuff part how are you doing this VBA or Query?

Thanks for your answer. Now for the hard part, how do you write this in VBA or Query?
Can you show me how to write this?

Intro to VBA

many Query help videos

Try the VBA video the second link will take you to a help page there must be at least 10 videos to get you started and answer many questions.   If you still need help let us know we can  go from there next.