You would need to use a circular reference
there is an example how you ca "freeze" time here

http://www.mcgimpsey.com/excel/timestamp.html


an example using today()


http://makeashorterlink.com/?R1932232D

scroll up a bit

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Rheyjune" wrote in message
...
I posted this once before but never actually saw it posted, so im trying
this
again.
My problem is as follows...
I am trying to track weekly sales day by day for the week (obviously),
anyway, my weekly sales sheet has the days of the week listed down collumn
B.
In collumn C, I need the correct date to appear, which it does by matching
the day in collumn B to the day posted on my daily report sheet (which has
the "today()" function. My problem is, for instance, Monday works just
fine,
pulls the date and the sales for the day into the correct collumns.
However
when Tuesday comes around, my Monday data changes because the daily report
sheet obviously now shows Tuesday.
What I need to know is, how can I get the formula to make no changes at
all
if the value is false.