Use either keyboard shortcuts or the NOW and TODAY functions to display the current date and time in Excel and Google Sheets spreadsheets together.

A. To enter the current date, select a cell and press Ctrl+; (that’s Ctrl and then the semicolon). To enter the current time, use Ctrl+: (the colon). These shortcuts work even when you are entering ...

If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.