Another option would be to create a "weeknumber" column, using something like:
=int((A2-date(2010,1,7))/7)*7+date(2010,1,7)
This should provide you with a new column showing the week-beginning date for each data row.
Now you could use the DAVERAGE function or a pivot table to extract and...