If you had explained all of this in your first post, things would have been much simpler.
Put 30/12/06-5/1/07, your first set of dates in cell A1.
In cell A2 enter the formula:
It is NOT two lines, it is a single very long formula, so Cut & Paste from this post so you get it right.
Drag down your 150 weeks, and just release and you should get your dates.
See how that works for you.