In the following I want to know the average for each day of the week based on the dates in Column B and the values in column C - but ignoring any blank cells

The actual columns are much longer than this and run into several months - this is just an example.

A formula would be greatly appreciated. Thank you