Current Date and Time
The best way to insert the current date and time is to use NOW function which takes date and time from the system and returns when you insert it in a cell.
The only problem with this function is it’s volatile and whenever you recalculate something it updates its value and if you don’t want to do this the best way is to convert it into value.
Otherwise, you can use below VBA code or these methods to insert a timestamp in a cell.
Dim ts As Date
.Value = Now
.NumberFormat = “m/d/yyyy h:mm:ss AM/PM”