Adding a date

[weedot]

I have a table that holds data thus

Hometeam Awayteam Weekno Date
teamA teamB 1
teamC teamD 1
teamE teamF 2
teamG teamH 2
teamJ teamK 3

The problem I have is allocating a date for each weekno ie both week 1 should have the same start date week 2 should be 7 days later etc. I have been struggling with this for days now have tried arrays, count etc but cant seem to crack this at all so would appreciate any input.

 

[namliam]

Is the weekno the normal weekno? or is it more or less random?

If you can figure out what is the start of week 1 then week 2 is simple, but you have to calculate the start of week1 first...