13 week average of data using dynamic dates

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.