How to Automatically Insert the Date Onto a Spreadsheet. Microsoft Office Excel offers many tools and processes for automating actions in spreadsheets.

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.

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

Q. Is there a quick way to enter dates and times in an Excel spreadsheet? A. To enter the current date, select a cell and press Ctrl+; (that’s Ctrl and then the semicolon). To enter the current time, ...