If you use Excel, sooner or later you will need to enter the date into a cell. The following shortcut inserts a snapshot of the date into a cell, formatted in whatever way the cell is formatted.
1. In Excel, open the worksheet you need to insert the date into.
2. Click the cell you wish to insert the date into
3. Type CTRL+; (press the Ctrl key followed by the semicolon key)
The date displays in the cell. Format it any way you wish (eg, long date, short date, colour, etc). It is a snapshot, so it will stay the same no matter what other date you open the workbook.
Was this tip helpful to you? Anything else you want to know? Please leave a comment below.
You’ll find more learning at Learning and Development