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.

Basic Formulas At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.

Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

Click OK. You can also “point” to the dates. For example, enter the End_Date in A4 and the Start_Date in A5. From Formulas > Function, select Date & Time, then select DAYS from the drop list.

If you type your dates in a different format than the one supported by your geographic location -- for example, "2012-12" in the U.S. -- Excel won't interpret your entry as a date.

Excel formula, you must first convert the referenced date cells to text; otherwise, you end up with an unexpected result. For example, suppose cell H11 ...

Microsoft is bringing its AI directly into Excel formulas with the Copilot function. It is designed to automatically analyze, ...

Microsoft Excel's Formula by Example helps automate repetitive tasks in structured tables in Excel for the Web. The tool is similar to Flash Fill, though it generates dynamic formulas that update ...

Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it ...