8 formulas
Date & Time
Calculate durations, working days, deadlines, and date differences with precision.
EDATEWORKDAYDATEDIF
Free · Excel & Google Sheets
AI Excel & Google Sheets Formula Generator
Describe your spreadsheet problem in plain English and get a copy-ready formula suggestion with a clear explanation you can adapt to your data.
Example output
“Sum sales where region is East and the date is in January 2024”
=SUMIFS(C:C, A:A, "East", B:B, ">="&DATE(2024,1,1), B:B, "<="&DATE(2024,1,31))- Filters sales column based on multiple criteria.
- Dynamic date range calculation for Jan 2024.
- Includes plain-English explanation and notes.
Category hubsBrowse formulas by the way
Browse formulas by the way
users actually search.
6 formulas
Math & Statistics
Add, count, average, and summarize spreadsheet data with criteria-aware formulas.
AVERAGEIFSCOUNTIFSMAXIFS
6 formulas
Financial
Model loan payments, net present value, internal rate of return, and depreciation.
PMTFVIRR
6 formulas
Array Formulas
Use dynamic arrays to filter, sort, deduplicate, and reshape data without helper columns.
SUMPRODUCTUNIQUEFILTER
7 formulas
Data Cleaning
Remove whitespace, fix casing, strip unwanted characters, and standardize messy data.
ISBLANKVALUECOUNTIF
9 formulas
Text Manipulation
Extract, combine, clean, and reformat text values from any cell or column.
CONCATPROPERLEN
4 formulas
Conditional Logic
Build formulas that branch cleanly when different business rules or thresholds apply.
ANDIFSSWITCH
4 formulas
Lookup & Reference
Reference formulas for pulling values across tables, finding matches, and building reliable lookup patterns.
HLOOKUPINDEXVLOOKUP
Popular formulas
View all library →Ready to copy.
Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Math & Statisticsintermediate
Average values by multiple criteria with AVERAGEIFS
=AVERAGEIFS(D2:D100,B2:B100,"East",C2:C100,"Q1")
Date & Timeintermediate
Calculate a due date skipping weekends with WORKDAY
=WORKDAY(A2,30)