Background:
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 Costs
column.
For the cells in column C
I use the following formula:
=if(D2="","empty",TODAY())
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.
Question:
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?