|In order to hard code a date/time in a cell you need to use a macro. |
Right click the sheet tab for the sheet in which you want this to happen and paste the following code into the pane that opens.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Target.Offset(0, 1) = Now
Posting Tip: Before posting Data or VBA Code, read this How-To.