Data Table, copy formula to next column and copy and paste values of a previous column

[ElBB23]

Hi all,

I have a data table with weekly dates across the top, within this table there is a sum if formula. I'm looking for a VBA that when opened if it is a Wednesday of the current week it drags the formula into the next column and copys/pastes values of an older column. (Basically just moving the formula range along one each week). Also, if the formula has moved across and the spreadsheet is opened again I don't want it to do anything until the following week.

Week 1

Wednesday of current week: 26/02/2020

Description	03/02/2020	10/02/2020	17/02/2020	24/02/2020	02/03/2020
Example 1	Value	Sum if Formula	Sum if Formula	Sum if Formula	Blank
Example 2	Value	Sum if Formula	Sum if Formula	Sum if Formula	Blank
Example 3	Value	Sum if Formula	Sum if Formula	Sum if Formula	Blank

Following week
Wednesday of current week: 02/03/2020

Description	03/02/2020	10/02/2020	17/02/2020	24/02/2020	02/03/2020
Example 1	Value	Value	Sum if Formula	Sum if Formula	Sum if Formula
Example 2	Value	Value	Sum if Formula	Sum if Formula	Sum if Formula
Example 3	Value	Value	Sum if Formula	Sum if Formula	Sum if Formula

Thanks in advance for the help,