| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding a fixed date to a cell
Hi, I want to add the actual date in cell A1 when B1 is populated for the
first time, A2 when B2 etc... I have tried the formula =today(), but the result is recalculated everytime the spreedsheet is opened. I have also tried to turn off auto-calculation, but I need the calculation on new entries. When I calculate manually, every cell is updated. I have tried to create a macro that fill the cell as a date instead of a formula (the command ctrl+shift+;) and that works, but I would like this to happen automatically when the user enter, exit or pick a value in cell. Does anyone have any suggestions on how to make this happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Adding a control button to insert a date in the active cell. | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Extract date from cell | Excel Worksheet Functions | |||
Threaded Mode
