weekly sales

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.

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" <Rheyjune@discussions.microsoft.com> wrote in message
news:6E91F4BE-528F-4ED8-8E01-9A7FD5BE252D@microsoft.com...
>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.

For column C Monday's date,
set it to '=today()-weekday(today(),3)'

"Rheyjune" <Rheyjune@discussions.microsoft.com> wrote in message
news:6E91F4BE-528F-4ED8-8E01-9A7FD5BE252D@microsoft.com...
> 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.

Definitely appreciate the quick response and assistance. Formula works just
fine. As for the Tue, Wed, Thurs etc etc I just used the formula current date
+1 for each concecutive day. works fine for now, however, if you foresee any
issues with that please let me know.
You guys rock!!! thanks again

"PY & Associates" wrote:

> For column C Monday's date,
> set it to '=today()-weekday(today(),3)'
>
> "Rheyjune" <Rheyjune@discussions.microsoft.com> wrote in message
> news:6E91F4BE-528F-4ED8-8E01-9A7FD5BE252D@microsoft.com...
> > 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.
>
>
>