Excel formula help

Good Day Everyone is there any way i can link the cells below a cell that contains date. so that when i change the display week it will also change. here are some screenshots that will further explai...