Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); AND, OR, NOT functions; and COUNT, AVERAGE, and MIN/MAX.
The basic functions covered below are among the most popular formulas in Excel—the ones everyone should know. To help you learn, we’ve also provided a spreadsheet with all the formula examples we cover here.
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 TODAY function reveals the current month, day, and year; while the NOW function reveals the current month, day, year,…