I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter in the
For the cells in column
C I use the following formula:
The problem with this function is that it updates everyday. As you can see from the picture the date on
C appears as the most current date although the information there was inserted days ago.
How do I achieve that the content in the cells of column
C stay only on the date of insertion content to column
D and they do not update everyday to the current date?