How to insert Current Date and Time in MS Excel using Formula
Insert Current Date and Time in a MS Excel cell using formula
Lets continue with Excel tips & tricks.
#2: 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.