Excel Formula to Calculate Age from a Birthday
DATEDIF age formulas for whole years or years-and-months, plus an INT approximation.
Read articleFormula guides
Copy-ready formulas for common Excel, Sheets, and WPS tasks.
Excel Formula to Extract Domain from an Email Address
Pull the domain from an email in Excel with TEXTAFTER or MID/FIND for older versions.
Read articleExcel Formula to Round to the Nearest 0.05 or 5
Round Excel numbers to 0.05 or 5 with MROUND, CEILING, FLOOR, or a ROUND workaround.
Read articleExcel Approximate Match VLOOKUP for Tax Brackets
Approximate VLOOKUP and XLOOKUP for tax brackets and other sorted threshold tables.
Read articleExcel Formula to Flag Rows That Meet a Condition
Build an Overdue/OK flag column with IF and AND, plus 1/0 flags you can SUM.
Read articleExcel Formula for Year-over-Year Growth
Year-over-year growth, zero-safe rates, last-year SUMIFS, and a five-year CAGR formula.
Read articleExcel COUNTIFS Between Two Numbers
COUNTIFS formulas that count values between two numbers, with category and AVERAGEIFS variants.
Read articleExcel LEFT, MID, and RIGHT: Extract Text Formulas
Extract SKU parts with TEXTSPLIT or LEFT/MID/RIGHT and FIND on older Excel.
Read articleExcel IFERROR VLOOKUP: Replace #N/A with a Message
Wrap VLOOKUP in IFERROR, chain a second table, or use XLOOKUP’s if_not_found argument.
Read articleGoogle Sheets ARRAYFORMULA with IF
ARRAYFORMULA+IF patterns that auto-fill Google Sheets columns as new rows appear.
Read articleWPS Spreadsheet SUMIF / SUMIFS with Multiple Criteria
WPS-safe SUMIFS and SUMPRODUCT formulas for multiple criteria without Excel 365 functions.
Read articleExcel SUMIFS as a Live Alternative to a Pivot Table
Build a live Excel crosstab with SUMIFS instead of a pivot table, including date filters.
Read articleExcel Formula to Highlight or List Duplicate Values
COUNTIF formulas that label, highlight, or list duplicate Excel values.
Read articleExcel Formula for Currency Conversion
Multiply by a locked FX cell, look up rates with VLOOKUP, and ROUND converted amounts.
Read articleExcel RANK Formula That Handles Ties
RANK.EQ, RANK.AVG, and unique-rank formulas for Excel leaderboards with ties.
Read articleExcel FILTER Formula for a Unique, Conditioned List
FILTER+UNIQUE lists of Excel values that match AND/OR criteria, with SORT and multi-column spills.
Read articleExcel Formula: Sum Values Between Two Dates
Copy-ready SUMIFS formula to sum Excel values between two dates, plus variations for named cells and the current month.
Read articleExcel XLOOKUP vs VLOOKUP: Exact Match Formula
When to use XLOOKUP instead of VLOOKUP, with copy-ready exact-match formulas and INDEX/MATCH fallbacks.
Read article