How do I do this in Excel 2003?
 

Column A is just an ascending list of dates of every day from 1/1/1970
to today. Column B are data associated with each day.

Elsewhere on the same worksheet I would like to be able to enter a
date in one cell, a number in another cell (let's call the number
"N"), and in a third cell have a formula that takes that date and
number, looks into the above data, and calculates an N day average of
the Column B data from that date forward.

Any help would be much appreciated.

Thanks

How do I do this in Excel 2003?
 

On Sun, 13 Apr 2008 17:13:25 -0400, TY wrote:



Column A is just an ascending list of dates of every day from 1/1/1970
to today. Column B are data associated with each day.

Elsewhere on the same worksheet I would like to be able to enter a
date in one cell, a number in another cell (let's call the number
"N"), and in a third cell have a formula that takes that date and
number, looks into the above data, and calculates an N day average of
the Column B data from that date forward.

Any help would be much appreciated.

Thanks


Try this:

The date is in cell C1, the number N is in cell D1.
in cell E1 you put

=AVERAGE(OFFSET(A1,C1-A1,1,D1,1))

Hope this helps / Lars-Åke

How do I do this in Excel 2003?
 

Lars-Åke Aspelin wrote:


Try this:

The date is in cell C1, the number N is in cell D1.
in cell E1 you put

=AVERAGE(OFFSET(A1,C1-A1,1,D1,1))

Hope this helps / Lars-Åke


That works! Thank you very much.

TY