Then save and close this code to return to the worksheet, now when you change the cell value or type new data in Column B, the date and time will be recorded automatically in Column C. In the above code, you can modify the “B: B” to any other column that you want to change the cell values in this script: script, you can insert and update the date and time to the first column next to your changing value column, you can change the number 1 to other numbers, such as 2,3,4,5…that means the date will be inserted the second, third, fourth or fifth column besides your changed values column.3.Let's say that you want to easily enter the current date and time while making a time log of activities.Or perhaps you want to display the current date and time automatically in a cell every time formulas are recalculated.There are several ways to insert the current date and time in a cell.A timestamp is something you use when you want to track activities.
But, in this article, you can solve this task with following steps.
If you have to insert the date and timestamp in few cells in Excel, doing it manually could be faster and more efficient.
Here is the keyboard shortcut to quickly enter current Date in Excel: Control : (hold the control key and press the colon key).
You'll be able to ask any tech support questions, or chat with the community and help others.
It is easy for us to insert static date and time manually or insert a dynamic date changing with the system time with a formula.