|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Generate an Absolute Date in a Cell
Check out
http://www.mcgimpsey.com/excel/timestamp.html
In article . com,
"nick" wrote:
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?
|