Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weekly sales
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weekly sales
For column C Monday's date,
set it to '=today()-weekday(today(),3)' "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weekly sales
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sales charts | Excel Discussion (Misc queries) | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Calculate Total Sales from a Database | Excel Worksheet Functions | |||
Weekly and Monthly Subtotals | Excel Discussion (Misc queries) |