Shifting cell values based on date

Hi, welcome to the forum

Not sure I am reading correctly, but just so you know, Conditional Formatting is a cosmetic visual appearance to a cell, it does not affect the contents of a cell at all. Also, no formula can "overwrite" the data/value of another cell, they only affect the cell they are in.

I suggest that you upload a (clean) sample workbook, showing what you have, and what you want

Here is an example of what I am trying to do.

1.JPG



Say on a given week I have a table that looks similar to the above example.

w/e 01/15 & 01/08 will automatically shift right based on the formula =L2-WEEKDAY(L2+1) at the end of the next week.

What I want is for the c's and x's underneath those heading to shift with them, as shown below.

2.JPG

I hope this provides some clarification.

You might take advantage of the freeze panes feature on the view tab to "scroll" columns off/on of the screen while keeping your titles in sight. I would point out that there are 16,800+ columns and 52 weeks in a year, so whatever you are documenting with the c's and x's you would be able to do so for over 323 years. That means you don't have to conserve blank columns if that is the reasoning behind wanting ant the least recent week to fall off. Sorry not to be of more help, but let me know if is anything with which I might assist.

What I want is for the c's and x's underneath those heading to shift with them, as shown below.

Are they entries, or from a formula? If entries, then apart from VBA, I see no formula-way to make them move