Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Tracking survey data | Excel Discussion (Misc queries) | |||
Tracking data by month | Excel Discussion (Misc queries) | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
Tracking data | Excel Discussion (Misc queries) | |||
template with data tracking | Excel Discussion (Misc queries) |