Formula guides

Copy-ready formulas for common Excel, Sheets, and WPS tasks.

Excel Formula to Calculate Working Days Between Dates

NETWORKDAYS and WORKDAY formulas for business-day counts, custom weekends, and holidays.

Build a unique Excel list with UNIQUE/FILTER, or a COUNTIF helper column for Excel 2016.

Join Excel cells with TEXTJOIN, including skip-blanks and an ampersand fallback for Excel 2016.

Google Sheets QUERY examples for WHERE filters, ORDER BY, GROUP BY, and dates.

SUMPRODUCT patterns for AND/OR criteria and weighted averages, plus when to switch to SUMIFS.

Convert text dates in Excel with DATEVALUE or DATE+LEFT/MID for yyyymmdd strings.

Split first and last names in Excel with TEXTBEFORE/TEXTAFTER or LEFT/FIND for older versions.

Two-criteria INDEX/MATCH formula for Excel, plus XLOOKUP and SUMIFS alternatives.

Nested IF, AND, and OR patterns for priority labels, with an IFS alternative for newer Excel.

Count distinct Excel values with UNIQUE+FILTER, plus a SUMPRODUCT version for Excel 2016.

When to use XLOOKUP instead of VLOOKUP, with copy-ready exact-match formulas and INDEX/MATCH fallbacks.

Copy-ready SUMIFS formula to sum Excel values between two dates, plus variations for named cells and the current month.