Log file where each line gets a date stamp when populated and where date is then stored as value

[pluginguin]

I have a simple log file with a couple of columns to log events. One row for each event.
Every cell in a row is manually entered and there are no macro's or formula's yet.
To prevent mistakes I now want to make a modification in column A... the date column.
As soon as one of the other cells in the row is populated I want the cell in column A to be populated with the date of today.
This can be achieved with a formula. But here is the challenge:

Once the row is populated and the date stamp is there, I want to change the date into a normal date value, so it doesn't change anymore if cells are emptied again or the file is reopened.
The rest of the column should still have the formula in place for future events.

I can find many posts about date formulas and worksheet change by value code but nothing where these two requests are bundled and comprehensive.

Can someone help me out please?

Thanks in advance

 

[footoo]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel as Range
Application.EnableEvents = False
For Each cel In Intersect([A:A], Target.EntireRow)
    If Len(cel) = 0 Then cel = Date
Next
Application.EnableEvents = True
End Sub