Averaging data across a date range

B

Barry

I am trying to calculate moving averages based on date ranges determined by
the user, i.e. the user sets the date as say 12.01.2009 and the spreadsheet
autocalculates the 1 year, 3 year, 5 year, 10 year and 20 year moving
average.

My problem is determining how to get the system to automatically set a range
based on the date selected, i.e. if user sets 12.01.2009 as the date it picks
up values in the range to average for say the last 12 months back to
12.01.2008 as an example and calculates the average over that range.

Any help welcome.
 
B

Bernard Liengme

Are the dates sequential?
One for each month?
What version of Excel (in Excel 2007 AVERAGEIFS might be useful)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top