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:
- To enter the current date into the worksheet, press down theCtrl keyboard key and press the (;) semicolonkey.
- 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:
- Insert =today() into a cell to return the currentdate.
- Insert =now() into a cell to return the current date andtime format.