You asked two questions.
The first one: If the cell (say A1) is blank and someone enters something
into that cell, the following formula will tell you the date and time that
occurred. However, this formula will update each time the sheet is
calculated (even though A1 has not changed) so I don't think you want that.
The second question concerns recording when data was last modified. That
will take VBA. In fact, VBA will be necessary for both. HTH Otto
"Maistrye" wrote in
message ...

Is there any way, without using VB, to record when data was entered in a
cell? Is there any way, without using VB, to record when data was last
modified?

Someone else asked me this, and I'm sort of skeptical, as I don't think
there is a way to manipulate formulae to do this.

We haven't decided what the punishment is for whomever is wrong.

Thanks in advance,
Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile:
http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=560185