You can do it easily with a pivot. I did one in about 2 minutes using your example. Do you know how to do that? I would attach my own but for some reason the attachment manager isn't working for me.

The key is to group the dates by Month/Year and then set up the Time value as average.