Forum Discussion
Adding today's date in date column in new row of a table
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!
4 Replies
- Thank you dscheikey and HansVogelaar for your help with this!
- I am currently using the following formula...
=IF(ISBLANK(M2),TODAY())
Where column M is my date column. I get a date to return, but excel keeps returning 1/0/1900 as today's date.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.
Don't forget to allow Iterative Calculation in File > Options > Formulas.
