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

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.

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.