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.
Rather than entering the formula
=TODAY()
touch Ctrl + ;
instead. This will put a "frozen" date in the cell.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With