Calculating the average of the last 14 days in Google Sheet

I would like to find a formula that takes into account the data of the last 14 days in column D and calculates the average. But I would like it to be updated dynamically everyday so that it always shows the average of the last 14 days depending on the current date.

Does it make sense? Is it possible?

Thank you for helping a newb

https://docs.google.com/spreadsheets/d/1C8paoYXirR5qus8axs-SciRqxeaBWMxsSmC0PGX969E/edit?usp=sharing