I know that [=NOW ()] delivers the current date and time; depending on how the cell is formatted, but that function is dynamic and, if left in the cell, changes over time.
I read somewhere that you can copy the result of that formula the paste it back, as data, to convert it to as static...