Tracking Data

L

LV

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?
--
 
K

Kevin B

You could use a formula to post the date and protect the column that contains
the date formula so it can't be tampered with.

Let's say the date is in column A and the test score is in column B. The
formula would look like the following:

=IF(ISBLANK(B1),"",TODAY())

Hope this helps...
 
K

Kevin B

Disregard my previous post, the TODAY() function will update with each
passing day.

I was a bit too quick on the trigger finger. My sincerest apologies.
 
J

JMay

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
 
L

LV

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.
 
Top