Adding date to cell

[Brianfree]

Hi, i have this fintion that displays the current date in a field if another cell is not empty..

=IF($A2<>"", NOW(),"")

works ok, however if i open the file tomorrow and update another row, the new date is ok but the old date changes..

how can i fix this??

many thanks,

Brian

 

[SkipVought]

Brian,

There is a sheet formula that I don't care to use, probably someone will post.

I much prefer a VBA (macro) using the Worksheet_Change event. This can be pasted in the Sheet Object code window, by right-click the sheet tab, select View Code

Private Sub Worksheet_Change(ByVal Target As Range)
'adds a date to column AA rather than
'=IF($A2<>"", NOW(),"")
    Dim COL As String
'CHANGE THIS for your column
    COL = "AA"

    If Target.Count > 1 Then Exit Sub
    
    If Target.Column = 1 Then
        With Cells(Target.Row, COL)
            .Value = Now
            .NumberFormat = "yyyy-mm-dd hh:mm"
        End With
    End If

End Sub

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}