One way you could do this is with a worksheet change event. For example
if you wanted the date in column B every time data in column A was added
(or changed) then:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrorHandler
Application.EnableEvents = False
If Target.Count = 1 And Target.Column = 1 Then
Cells(Target.Row, 2).Value = Date
End If
ErrorHandler:
Application.EnableEvents = True
End Sub

This is worksheet event code. Right click the sheet tab, select view
code and paste the code in there.

Hope this helps
Rowan
Earnest er wrote:
In a long list, witrh emty rows, I need to add frequently new names, if there
is a way that a formula adds the date that name were added, it would be great!
Any ideas?