|I guess you confused me with this line:|
So... if A1 has any data B1 will show the current date.
Current to me meant current at all times.
To place the date (and time) automatically when the cell is changed, but not have it change when you open the file, you have to use a Change Event macro.
Whenever A1 is changed this code will put the value of Now() in the cell, instead of the ever-changing NOW() function.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Range("B1") = Now()
Right-click the sheet tab, choose View Code and paste this in the window that opens.