I'd like to be able to enter today's date into a cell in Excel. Doesn't
sound too hard, does it? Except, I'd like to be able to leave the date as it
was the next time I open the file and not have Excel update the damn thing to
the current date. It still doesn't sound too hard, does it? I want to be
able to detect data being entered into one cell and put the date the data was
first entered into another as some sort of audit trail without the date
changing every time I look at it. I cannot find a function to do this
(seemingly) simple task; am I missing something?

Thanks in advance for any help, just in case I am.

To enter today's date into a cell, use Control + semi-colon.
--
David Biddulph

"matchwalk" wrote in message
...
I'd like to be able to enter today's date into a cell in Excel. Doesn't
sound too hard, does it? Except, I'd like to be able to leave the date as
it
was the next time I open the file and not have Excel update the damn thing
to
the current date. It still doesn't sound too hard, does it? I want to be
able to detect data being entered into one cell and put the date the data
was
first entered into another as some sort of audit trail without the date
changing every time I look at it. I cannot find a function to do this
(seemingly) simple task; am I missing something?

Thanks in advance for any help, just in case I am.

The whole point of this is to automate the entry of a date into a cell, not
have to enter it manually. This is the scenario...
I have a risk register. When I commence input of a new risk, I'd like the
entry to be assigned an index number and have the date of creation entered
automatically in another cell. Say column A contains the index numbers and B
the dates of creation; I commence entering details of a risk into cells C-H.
As soon as non-empty cells are detected in any of the columns C to H
inclusive, the index number should be entered into A, incrementing from the
index in the previous row, and the current date should go into B. Neither of
these should change when I open the log on any other occasion. A real bonus
would be if one cell (column) could contain 'last date this entry (row) was
edited' but that might just be too much to ask...




"David Biddulph" wrote:

To enter today's date into a cell, use Control + semi-colon.
--
David Biddulph

"matchwalk" wrote in message
...
I'd like to be able to enter today's date into a cell in Excel. Doesn't
sound too hard, does it? Except, I'd like to be able to leave the date as
it
was the next time I open the file and not have Excel update the damn thing
to
the current date. It still doesn't sound too hard, does it? I want to be
able to detect data being entered into one cell and put the date the data
was
first entered into another as some sort of audit trail without the date
changing every time I look at it. I cannot find a function to do this
(seemingly) simple task; am I missing something?

Thanks in advance for any help, just in case I am.