Entering dates and times in Microsoft Excel 2019

You will find steps to add the current date and time into a worksheetcell. Note that neither of these entries will update should the workbookbe closed and opened at another date or time:

  1. To enter the current date into the worksheet, press down theCtrl keyboard key and press the (;) semicolonkey.
  2. To enter the current time into the worksheet, press down theCtrl and Shift keyboard keys and press the(:) colon key.

To insert a date and time that updates automatically every time theworkbook is opened, do the following:

  1. Insert =today() into a cell to return the currentdate.
  2. Insert =now() into a cell to return the current date andtime format.

Leave a Comment