Insert the current date and time in a cell - Office Support
When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell. Because that cell’s value doesn’t change, it’s considered static. On a worksheet, select the cell into which you want to insert the current date or time.
DA: 8 PA: 32 MOZ Rank: 14