Is it possible to automatically insert a date in one cell in MS excel 2007

Question

I have one excel document with two columns. I only add text to one column daily, and I want the current date and time to be automatically added to the second column.

This field can also be hidden, and I can get it when I want, but I want the time of the date when I added to this line

Is it possible

Answer 1

Try the function TODAY()or NOW()? He will return today's date. Be careful if tomorrow , if you open the spreadsheet, the cell will show the date tomorrow. Thus, you will need to have a macro and insert values ​​only in the date cell.

, , , - CTRL + ; CTRL + : . , , . , , , .

Answer 2

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C:IV")) Is Nothing Then
    Cells(Target.Row, 1) = MonthName(Month(Date))
    Cells(Target.Row, 2) = Date
End If
End Sub