In Microsoft Excel, you can input the current date and time either as a static or dynamic value. Timestamping is entering a "static date" that won't change with the course of time or when the spreadsheet is recalculated.So, if your goal is to enter the current date and/or time as a static value that won't automatically update the next day, you can use one of the following shortcuts: For starters, I'd like to note that I'm very hesitant to post the solution because it involves circular references, and they should be treated with great care. Let's say you have a list of items in column A, and as soon as a certain item is shipped, you enter "Yes" in the Delivery column, which is column B.To fix this, double-click the right border of the column to auto fit the date, or drag the right border to set the desired column width.
In a moment, you will learn all these and a few more date entering techniques.
I believe you are asking to capture the value of current cell only at a specific time.
Instead of using several options and formulas, a simple VBA code will do the work for you. please refer to it and manipulate it as per your requirements.
Once "Yes" is in there, you want to have the current date and time automatically inserted in the same row in column C as a static unchangeable time stamp.
To do this, we are going to use the following nested IF formula with circular references in the second IF function: column, and C2 is the cell where you input the formula and where the time stamp will eventually appear.