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

An Excel formula is generally composed of several items. Knowing how to calculate formulas in Excel will make tracking various parts of your business that much easier.

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.

We explain how to fix the issue when Excel is not auto-calculating formulas. Excel is an advanced tool when calculating formulas for statistics.

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

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.