Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i set up an automatic "date update" in excel? | New Users to Excel | |||
Automatic update of date once, then remains static | Excel Worksheet Functions | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
Automatic Date Update | Excel Worksheet Functions | |||
Automatic Date Update | Excel Discussion (Misc queries) |