Excel Formulas

Use an Excel formula to count days from a date to today automatically with TODAY, DAYS, DATEDIF or NETWORKDAYS. The count updates every day on its own.

Learn how to COUNTIF in Excel with multiple criteria using COUNTIFS, operators, SUM with COUNTIF for OR logic, and SUMPRODUCT, with worked examples.

Learn how to find the range in Excel with MAX and MIN, then get the range of filtered rows with SUBTOTAL or by group with MAXIFS and MINIFS.

Learn how to use XLOOKUP in Excel with two workbooks to find and return matching data across separate Excel files quickly and accurately.

Learn how to limit decimal places in Excel formulas using ROUND, TRUNC, ROUNDUP, and ROUNDDOWN for accurate and clean calculation results.

Learn how to calculate the number of weeks between two dates in Excel using simple formulas, full weeks, working weeks, and rounding methods.

Learn the best Excel formulas to extract numbers from text. Simple to advanced methods for cleaning data quickly. Fix messy spreadsheets.

Learn how to use XLOOKUP to find the closest match in Excel. Step-by-step examples for next smaller and next larger values.

Learn the simple Excel formula to reduce a number by a percentage. Step-by-step guide with examples for discounts, sale prices, and bulk calculations.

Learn how to add live formulas in text boxes in Excel using cell linking, VBA, and Camera tool. Create dynamic dashboards that update automatically!