eg, A1 contains a numerical value (based on a formula)

Each day there is a new column, say, Monday = B1, Tuesday = C1 etc.

On Monday B1 takes the value of A1 and 'freezes' the value in B1

On Tuesday C1 takes the value of A1 and 'freezes' the value in C1, but the value in B1 remains as it was when it was originally frozen.

Any help on this would be greatly appreciated!!