I have 3 columns of cells that are conditionally formatted. They are aligned with different headings that correspond to the weekending date who get their values from variations of =today(). My question is if there is a formula that will automatically shift the values of the conditionally formatted cells to stay aligned with their originally corresponding weekending date as that weekending date shifts based on =today(). It would also have to subsequently overwrite the cell value of the least recent week that would then fall off.

I hope my question wasn't as confusing as it seemed it was trying to word it.