View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Pinkney.Chandra@gmail.com is offline
external usenet poster
 
Posts: 1
Default Automatic Data Update by Date Range

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