Hi am making a spreadsheet that logs issues in a specific project.
When the user logs an event. I would like for excel to input the date that the person logged the information into the spreadsheet.
Currently my formula utilizes the TODAY function but I realized that the date will continue to update to the present date. I would like to log a date when data is entered into a cell, and that date will not update to present time.
Below is an example of my formula i have currently.
Cell H2: Formula: =IF(I2=2,TODAY(),XX)
Cell I2= TYPE(K2)(this cell is hidden to the user) Type displays number 2 when text is the value of the referenced cell.
Cell K2= User Data log info.
I would like to change H2's formula to a date that will not update to the present date.
Thanks
Bookmarks