Rotating weekly dates - if date is passed then go to next weeks date

I am not sure how well I can explain this so I have added the spreadsheet and highlighted what needs to change and what it needs to be changed to.

Basically I have a weekday list from Sunday to Saturday that needs to rotate the dates around once they have passed. The days of the week do not rotate only the dates.

Hopefully it makes sense once you see the spreadsheet because I have no idea how to explain it well

See attached file. The formula for Sunday (A7) is:

=IF(WEEKDAY($N$1)=1,$N$1,A19+1)

For Monday (A9):

=IF(WEEKDAY($N$1)=2,$N$1,A7+1)

This can be copied into the other cells, changing the 2 in red each time (i.e. Tuesday = 3, Wednesday = 4, and so on).

The yellow conditional formatting is obtained using a rule of Cell value > $N$1

Hope this helps.

Pete

Thanks for your help.

This worked just fine.

Had to do some creative conditional formatting to get it to do what I wanted but I finally got there

Glad it worked for you - thanks for the rep.

Pete