you could quickly add the current date toExcelusing shortcut keys on the keyboard.

The shortcuts may vary between Excel for Windows and Excel for Mac.

The default format for the date entered is the short date format as shown in the image above.

Illustration of Ctrl+; keys in a spreadsheet

Lifewire / Adrian Mangel

Use another keyboard shortcut to change the format to the day-month-year format.

The time does not change once entered.

The date and time will both appear in the selected cell.

Custom date and time formats in Excel

The key combination for accessing the Format Cells dialog is