Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

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.

One way to correct this behavior is to change your default date system. On the Mac version of Excel, you can do this within the calculation pane of Excel's preferences.