What I have is a number in A1, which changes nearly every day. I would like
to set up a formula in, let's say A2 that says something along the lines of
pull the value and A1 on the 14th of the month and store that value.
I was thinking of something like:
=IF( DAY( TODAY() )=14, A1, "")
but obviously, the value obtained on the 14th is erased the following day. I
would like cell A2 to hold this value from the 14th for the rest of the
month. Thanks in advance for any help.