Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or conditions, turning your spreadsheet chaos into organized data magic.

That way the Excel formula can reference the cells which you can easily change. Write the formula in Excel to reference your variable cells.

Your projections in Excel won't be useful or complete until you add additional formulas to calculate how your sales and expenses interact and play out over time.

How to Calculate Percentage Change Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.