How to freeze the today function once data has been entered

Question

In an excel table, I want to use the =TODAY() method. To properly capture the date the row's data was contributed, I would like that table row to never change dates after data has been uploaded.

Each date will be recorded as data is inserted into the database down the rows because this will be used on every row in the table.

If so, how do I go about doing it?

Answer 1

Don't enter this formula:

=TODAY()

Instead use  Ctrl + ;

This will put a "frozen" date in the cell.