Extract average based on date.

I have a an Excel (2007) spreadsheet that looks like this:

A B
- -
13/10/2015 348
13/10/2015 1679
13/10/2015 869
14/10/2015 2635
14/10/2015 672
14/10/2015 124

...and so on. In fact there could be a hundred or so entries for each day and up to 30 individual days.

What I want to do is: average all the values in column B for each day and put this average in another cell (in column C?), then step to the next day and do the same and put the result in a another cell in column C, and so on...

I must admit that I haven’t used Excel in anger for at least 6 years and I have forgotten the little I used to know

Any help would be much appreciated.

Do you have a sample spreadsheet you can upload?

Hi MagicMan,

Attached is an example...

It's ugly as sin, but I couldn't find a way to make it match a single date.

I've put a couple of control columns in (F and G) which takes one before your date and one after, the formula (in column H) then looks between those dates (i.e. your target date).

I'd hide columns F and G

I'm sure there must be a more elegant way of doing it.