Calculate weighted average based on a date

I need to be able to calculate the weighted average per date. This is the weighted average calculation =SUMPRODUCT(q1 score, q1 count)/SUM(q1 count)
The criterion is the date. I have attached a sample workbook. The data is in another sheet (Raw)