Enter the following macro in WorkSheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Offset(0, 1).Value = Now()
Application.EnableEvents = True
End Sub

If you are not familiar with VBA, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary's Student
gsnu200703


"cjensen" wrote:

I would like to know how to have excel aotomaticaly insert the date and tim
if the adjacent cell is in use. I need the date and time to reflect the time
that the entry was made and not change