Setting Dates

M

Maistrye

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

Someone else asked me this, and I'm sort of skeptical, as I don't thin
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,
Scot
 
O

Otto Moehrbach

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
 
Top