In short, I would like my date column (A) to be blank when I open the
spreadsheet. Upon entering text information, always a persons name, into
column (B) I would like Column (A) to automatically update to the day the
name was entered without changing the dates of the previously entered
information.

Thanks for the help!