| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values in cell based on system date
Hi... I have a value in a cell which is the percentage of work
completed in a day. This value changes automatically based on the values in the other sheets. Say it is 30 % on 23-Oct-2008 and the value is in cell D1. Now, I am trying to create in the sheet something like this, (Say today's date is 25-Oct-2008) A B 23-Oct-2008 30% 24-Oct-2008 50% 25-Oct-2008 70% 26-Oct-2008 Pending 27-Oct-2008 Pending Could you help me with a solution such that column B above, automatically changes values "everyday" based on cell D1 value? Thanks for your help. Vicky |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing cell values based on another cell | Excel Worksheet Functions | |||
| How can I get the system date & time for different cell record | Excel Discussion (Misc queries) | |||
| How can I increase the value in a cell based on the changing date | Excel Worksheet Functions | |||
| Changing color of single bar based on x-axis date value | Charts and Charting in Excel | |||
| Changing values in a row based on a cell in the row. | Excel Discussion (Misc queries) | |||
Threaded Mode
