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 ...
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.
=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.
