Oct 21 2022 07:45 AM
I have a date column in a table that has manually entered dates. I am wanting to utilize a formula to add the current day's date in the date column when a new row is added to the table. I would like to retain the current dates that were entered manually if possible as there are almost 10,000! I am sure this can be done, but I can't seem to figure it out!
Can anybody help with this? You will be my savior!
Oct 21 2022 12:48 PM
Oct 21 2022 01:15 PM
Hi, you could try the following. Assume that your new row is row 12. If an entry is made in column A, the value in column K, i.e. the date in K12, should be fixed.
Then you have to write in K12:
=IF(A12="",TODAY(),K12)
So the cell refers to itself and is therefore no longer updated.
Oct 21 2022 01:44 PM
Don't forget to allow Iterative Calculation in File > Options > Formulas.
Oct 24 2022 06:55 AM