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.

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

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use ...