=IF( DAY( TODAY() )=14, A1, "")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
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.