Setting Dates

[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

 

[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

 

[Guest]

Otto
the first one looks like its what I am trying to do, can you show the
formula please as it wasn't stated, I am trying to record the date in cell A1
every time a cell in a range of cells was edited, for example someone
entering their hours worked on any given day cell A1 will show that days date

I hope this explains it

Thanks in advance
Tommo