Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to freeze the =today() function once data has been entered [duplicate]

I would like to use the =TODAY() function in a table in excel. However, once data has been entered into that table row, I would like it never to change dates again (effectively capturing the date the row's data was added).

This will be used on every row in the table, so as data is entered into the table down the rows, each date will be captured.

Is this possible, how do I do it?

EDIT - pnuts it is not the same as this question. I do not want to use a button, rather a cell formula.

like image 955
David Avatar asked Aug 02 '15 11:08

David


1 Answers

Rather than entering the formula

=TODAY()

touch Ctrl + ;

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

like image 139
Gary's Student Avatar answered Oct 11 '22 13:10

Gary's Student