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

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 ...

The DATE function in Google Sheets automatically converts a year, month and day into a date format. Type "=DATE ()" into a cell and press "Enter" to display 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 it.

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

While Microsoft Excel automatically reformats time values as hours and minutes, you can manually change the cell's time format to display the seconds as well. Using the Function Library on the ...