Hi,

I would like to average column B if column A is between a certain date range.

Column A Column B

Date Amount
01/01/2015 £10.00
01/01/2015 £20.00
02/01/2015 £30.00
02/01/2015 £40.00
02/01/2015 £50.00
03/01/2015 £100.00
04/01/2015 £70.00
05/01/2015 £10.00
06/01/2015 £20.00
07/01/2015 £40.00
08/01/2015 £100.00

Date Average amount
01/01/2015 - 07/01/2015 £39.00
08/01/2015 - 14/01/2015 £100.00

Thank you in advance.

Rachael