Using three Microsoft Excel functions, you can easily parse time components from a full date value.

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

In many cases, you want people to enter a valid date, and no other type of information, when they're putting data into a cell in Microsoft Excel.

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

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

If you're using Microsoft Excel, you insert the current date in a spreadsheet with the Ctrl-; keyboard shortcut. Select a cell, press the "Ctrl" key and then enter ";" (semi-colon). Excel takes a ...

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 macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.