SpreadsheetFormulas

Formulas Categories Error Fixes Templates Tools Search formulasSearch

Search

Search by problem ("compare two columns"), function ("XLOOKUP"), or error ("#N/A").

Every formula tested before it's published.

Plain-English explanations, real sample data, and both Excel and Google Sheets versions — so you can copy with confidence.

Email address

New tested formulas and templates, about twice a month.

Popular categories

Lookup & Matching
Text Cleanup
Dates & Deadlines
Counting & Summarizing
Conditional Logic
Error Fixes

Site

All formulas
Error fixes
Categories
Templates
Tools
How we test
Search

=TEXT(TODAY(),"yyyy") → 2026 Spreadsheet Formulas

Verify formulas against your own data before using them in important work.