Formula ? Change on 15th of every month

[zone709]

HI,

Trying to see if this possible.


I have so many different sheets. I need something to change the 15th of every month

Right now i have this

=Sheet2!C4

So on November 15th i need it to pull this

=Sheet2!C5

Dec 15th

=Sheet2!C6

Only this change would be the number. Possible?

 

[zone709]

Thanks for the reply also.