OK - I think I may have worded the question wrong. I have data that is
already entered. I need to go back and look at the historical data and see
if the date the person entered as performing the test was actually the date
the data was entered into Excel. Is there a time stamp "behind the scenes"
that will allow me to see the date/time the data was entered besides the date
that the employee says he/she entered the data?

I'm trying to prove that data was not entered on the date that was entered
into the spreadsheet.
--



"JMay" wrote:

Use on your date entry cells Data Validation. With your first such cell
select it
At the menu, select Data, Validation, on the Settings tab select from the
allow dropdown: Date next box equal to in box type =Today() and OK Out.
Copy this cell down as far as is needed.

Only the current date can be entered


"LV" wrote:

I have a spreadsheet that employees have to enter a date and test result
into. Is there a way to find out if the data was actually entered on that
day? I.E. If the data is logged as 9/9/08, how can I prove that the data
was actually entered on that day?
--