How to change Cell refernce to other cells every 14 Days , By formula or VBA?

Question

I have data in A1 and data in B1 and Date in C1.

Now D1=A1 .

I need after 14 days from Date in C1, D1 to be = B1

and after 14 days again D1 to be = A1 and so on.

How to do that , By formula or VBA ?

Answer 1

You can try this:

=IF(ISEVEN(INT((TODAY()-C1)/14)),A1,B1)

or this:

=IF(ISODD(INT((TODAY()-C1)/14)),B1,A1)