Find Today's data and give 5 day avarage

[aletvdw]

I want to have a look at my <nobr style="margin-top: 0px; color: rgb(20, 20, 20); font-family: Verdana, Helvetica, Arial, sans-serif; font-size: 15px; line-height: 20px; background-color: rgb(252, 252, 255);">date</nobr> row for and find today's date, then I want to find the data 3 rows down corresponding with today's date

I then want to have the average of the last 5 days from the data in that row.

So if today is 20 September
I want to find 20 September in the top row say row a
Then I want to have a look at the data in row d for today data and get the average of that data for 15 -20 September

 

[Aladin Akyurek]

What is the range which houses the data including the top row of dates?

 

[aletvdw]

What is the range which houses the data including the top row of dates?

Hi have just started the spreadsheet 1 September with dates in row a data in b c and d and need the 5 day average of the data in d can be returned in row e.
will be doing this per year

I will use the formula in some of my old spread sheet for past years as well. but will sort those at a later stage

 

[Aladin Akyurek]

Hi have just started the spreadsheet 1 September with dates in row a data in b c and d and need the 5 day average of the data in d can be returned in row e.
will be doing this per year

I will use the formula in some of my old spread sheet for past years as well. but will sort those at a later stage

In case I'm not clear about what I asked for: J1:P10, A1:M40, are examples of ranges. So I wanted to know your current range of data.

 

[aletvdw]

In case I'm not clear about what I asked for: J1:P10, A1:M40, are examples of ranges. So I wanted to know your current range of data.

hi
just changed my rows and colums around to make it easier to read
I then tried this formula and now looks as if it is working

= AVERAGEIF($A$1:$AK$1, ">=" & (TODAY()-5), $A$3:$AK$3)

thanks for being willing to help much appreciated