Generate an Absolute Date in a Cell

  • Thread starter Thread starter nick
  • Start date Start date
N

nick

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?
 
nick said:
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?
Click to expand...
If you are using the MSN Quote add-in, one of the parameters you can
download is the date & time) of the last trade.

ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
AI Art Generator 12
absolute reference fill 1
Dates 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Can I insert in a cell the "date revised" (in a worksheet,etc) 1
Auto enter current date in cell when another changed 7
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Back
Top