| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Generate an Absolute Date in a Cell
I have to regularly update a spreadsheet with stock prices but can
only do a certain number per day. I therefore need to see the last time I updated any cell. I would like to automatically generate an absolute date in the next column cell showing the date the modification was made. I have looked at functions such as TODAY() but these will automatically update whenever I open the worksheet - which I don't want. Is this possible in excel & ideally without using a macro? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| Change cell to red when date in other cell is red | Excel Discussion (Misc queries) | |||
| extract name when a date in another cell gets near | Excel Worksheet Functions | |||
| Extract date from cell | Excel Worksheet Functions | |||
Threaded Mode
