DATE/TIME STAMP

[luisitocarrion1900]

Am looking for A FORMULA THAT IF A DATE IS ENTER IN COLUMN E POUT A DATE/TIME STAMP ON COLUMN G TO SHOW THE DATE AND TIME THE DATE WAS ENTERED, ALSO WOULD LIKE TO KNOW IF IN CLOLUMN H IT WOULD ENETER THE USERS NAME.

 

[rlv01]

I don't know of a formula that will do that. Pressing the key combination Ctrl + ; and Ctrl + Shift + ; will insert a time stamp. Beyond that, it will probably require a VBA solution.

One way.

'
' Add to worksheet code module
'
Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Application.Intersect(Me.Columns("E"), Target) Is Nothing And Target.Cells.Count = 1 Then
        With Target
            If TypeName(.Value) = "Date" Then
                .Offset(0, 2).Value = Date & " " & Time
                .Offset(0, 3).Value = Environ("COMPUTERNAME") '<- use whatever environment variable you think best for a User ID.
            End If
        End With
    End If
End Sub