To insert the current date in Microsoft Excel 2019

  1. Click on cell A1 to enter the system date. Type the formula=TODAY() in the cell. Press Enter on thekeyboard.
  2. The date displays in the current cell and will update each time youopen the workbook.
  3. To enter the current date without updating, use the keyboardshortcut Ctrl and ;.
To enter the current time, use the keyboard shortcut Ctrl+ Shift + ; .

Leave a Comment