1. TODAY/NOW. There are 24 Date and Time functions listed on the drop-down menu under Formulas > Date & Time: 11 Date formats, 10 Time formats, and as many user-defined custom formats you can create.

The Excel NOW function works the same as the TODAY function, however it returns both the current date and time when the spreadsheet is open. This is handy for a master spreadsheet you may use ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.