If you need to display the current date and time in Excel or Google Sheets spreadsheet, you can do it quickly. There is more than one method to show the current date and time in a spreadsheet.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

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.

If you type the =Today() function in any cell and press Enter, Excel will show you the current date. Therefore, this method is used to highlight the rows with dates earlier than the current date.

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

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

Excel's Date & Time functions help you calculate a day's serial number, move to a 360-day accounting calendar, and more. We cover Date, Days, Days360, Time, and Weekday ...

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.