Thread: Tracking Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Tracking Data

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...
--
Kevin Backmann


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