CODEWITHSUNDEEP
excelvbaformula
Leedo
Leedo

Reputation: 611

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

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 ?

Sheet Image

Upvotes: 2

Views: 98

Answers (1)

VBasic2008
VBasic2008

Reputation: 54853

You can try this:

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

or this:

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

Upvotes: 2

Related Questions