P
Pinkney.Chandra
Is there a way to have a cell update through a date range from data
entered in another cell?
An Example...
Each day a numerical value will be entered in cell A1 (number of
people who purchased product)
I would like for cell B1 to automatically update the data each day for
1 week from the amount entered into A1 on each day.
If entering 1 in cell A1 on Mon, 3 on Tues, 1 on Wed, 1 on Thur, and 2
on Fri
Cell B1 should have a total of 8 on Fri.....This would update a by
Week, another cell by Month and another cell by Quarter
1. Would I need to clear data from Cell A1 each day to enter a
different number for the next day?
2. Will cell B1 require a cut off time for each day?
Thanks
entered in another cell?
An Example...
Each day a numerical value will be entered in cell A1 (number of
people who purchased product)
I would like for cell B1 to automatically update the data each day for
1 week from the amount entered into A1 on each day.
If entering 1 in cell A1 on Mon, 3 on Tues, 1 on Wed, 1 on Thur, and 2
on Fri
Cell B1 should have a total of 8 on Fri.....This would update a by
Week, another cell by Month and another cell by Quarter
1. Would I need to clear data from Cell A1 each day to enter a
different number for the next day?
2. Will cell B1 require a cut off time for each day?
Thanks