Is there a way to lock in a date that an entry is made. Ex: Col A1:A10
contains a formula to indicate a date that entry is made is B1:B10.

The formula setup in A1 that comes to mind is: =IF(B1="","",TODAY()). But
that date changes with each day. I want to lock in the date an entry is made.

Thanks,
Les