13 week average of data using dynamic dates

[MycomFA]

I need to get a 13 week average of data based on the current date each week. In addition, the average must be from a referenced row within that date column. I am currently using Hlookup’s for a 4 week average and was trying to avoid a lengthy formula for the 13 wk average if possible. Please see that attached example. Thanks.

[Ace_XL]

For 4-week average use
=AVERAGE(OFFSET($F$1,ROW()-1,MATCH($B$1,$F$1:$BF$1,1)-5,1,4))
For 13-week average use..
=AVERAGE(OFFSET($F$1,ROW()-1,MATCH($B$1,$F$1:$BF$1,1)-14,1,13))

[MycomFA]

Thank you. I just can't seem to get it to work for me. Can you tell me what the Row() is doing for the formula? It appears it is referencing the cell one less than the active cell. I would really appreciate it.

[Ace_XL]

The Row() function simply returns the row number in which the formula is. Hence Row()-1 would be the previous row

[MycomFA]

I finally figured it out. Thanks so much!