8 formulas
Date & Time
Calculate durations, working days, deadlines, and date differences with precision.
Functions: EDATE, WORKDAY, DATEDIF, TODAY, MONTH, EOMONTH, NETWORKDAYS, TEXT
Formula library
Explore formulas by category, not just by function name.
Search by use case, not just function name. Each category groups formulas by what they actually do — so you can find what you need even when you don't know which function to use.
6 formulas
Math & Statistics
Add, count, average, and summarize spreadsheet data with criteria-aware formulas.
Functions: AVERAGEIFS, COUNTIFS, MAXIFS, LARGE, STDEV, SUMIFS
6 formulas
Financial
Model loan payments, net present value, internal rate of return, and depreciation.
Functions: PMT, FV, IRR, NPV, SLN, RATE
6 formulas
Array Formulas
Use dynamic arrays to filter, sort, deduplicate, and reshape data without helper columns.
Functions: SUMPRODUCT, UNIQUE, FILTER, SEQUENCE, LET, SORT
7 formulas
Data Cleaning
Remove whitespace, fix casing, strip unwanted characters, and standardize messy data.
Functions: ISBLANK, VALUE, COUNTIF, TRIM, CLEAN, IFERROR, ISNUMBER
9 formulas
Text Manipulation
Extract, combine, clean, and reformat text values from any cell or column.
Functions: CONCAT, PROPER, LEN, MID, LEFT, RIGHT, SUBSTITUTE, TEXTJOIN
4 formulas
Conditional Logic
Build formulas that branch cleanly when different business rules or thresholds apply.
Functions: AND, IFS, SWITCH, IF
4 formulas
Lookup & Reference
Reference formulas for pulling values across tables, finding matches, and building reliable lookup patterns.
Functions: HLOOKUP, INDEX, VLOOKUP, XLOOKUP
50 formulas match your current filters.
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)
Financialintermediate
Calculate a fixed loan payment with PMT
=PMT(B1/12,B2*12,-B3)
Array Formulasintermediate
Calculate a weighted average with SUMPRODUCT
=SUMPRODUCT(B2:B10,C2:C10)/SUM(C2:C10)
Date & Timeintermediate
Calculate age in years with DATEDIF
=DATEDIF(A2,TODAY(),"Y")
Financialintermediate
Calculate future value of savings with FV
=FV(B1/12,B2*12,-B3)
Financialadvanced
Calculate internal rate of return with IRR
=IRR(B2:B7)
Financialadvanced
Calculate net present value with NPV
=NPV(B1,B3:B7)+B2
Financialbeginner
Calculate straight-line depreciation with SLN
=SLN(B1,B2,B3)
Financialadvanced
Calculate the interest rate of a loan with RATE
=RATE(B1*12,-B2,B3)*12
Data Cleaningbeginner
Check for empty cells with ISBLANK
=IF(ISBLANK(A2),"Missing","OK")
Text Manipulationbeginner
Combine address parts into one field with CONCAT
=CONCAT(A2,", ",B2,", ",C2," ",D2)
Conditional Logicbeginner
Combine conditions with AND and OR
=IF(AND(B2="Active",C2>1000),"Qualify","Skip")
Data Cleaningbeginner
Convert text to numbers with VALUE
=VALUE(TRIM(A2))
Text Manipulationbeginner
Convert text to proper case with PROPER
=PROPER(A2)
Text Manipulationbeginner
Count characters in a cell with LEN
=LEN(A2)
Date & Timebeginner
Count days remaining until a deadline with TODAY
=A2-TODAY()
Math & Statisticsintermediate
COUNTIFS for active customers by segment
=COUNTIFS($B:$B,"Active",$C:$C,$G$2)
Conditional Logicintermediate
Evaluate multiple conditions with IFS
=IFS(A2>=10000,"Gold",A2>=5000,"Silver",A2>=1000,"Bronze",TRUE,"Standard")
Text Manipulationintermediate
Extract a substring from the middle with MID
=MID(A2,5,3)
Array Formulasbeginner
Extract a unique list with UNIQUE
=UNIQUE(A2:A100)
Date & Timebeginner
Extract month and year from a date with MONTH and YEAR
=YEAR(A2)&"-"&TEXT(MONTH(A2),"00")
Text Manipulationbeginner
Extract the first N characters with LEFT
=LEFT(A2,3)
Text Manipulationbeginner
Extract the last N characters with RIGHT
=RIGHT(A2,4)
Array Formulasintermediate
Filter rows by a condition with FILTER
=FILTER(A2:C100,B2:B100="East","No results")
Math & Statisticsintermediate
Find the maximum value by criteria with MAXIFS
=MAXIFS(D2:D100,B2:B100,"East")
Math & Statisticsbeginner
Find the Nth largest value with LARGE
=LARGE(B2:B100,1)
Data Cleaningbeginner
Flag duplicate values with COUNTIF
=COUNTIF($A$2:$A$100,A2)>1
Array Formulasbeginner
Generate a number sequence with SEQUENCE
=SEQUENCE(10)
Date & Timebeginner
Get the last day of a month with EOMONTH
=EOMONTH(A2,0)
Lookup & Referenceintermediate
Look up a value across a row with HLOOKUP
=HLOOKUP(B1,$B$1:$F$5,3,FALSE)
Conditional Logicintermediate
Match a value against exact cases with SWITCH
=SWITCH(A2,"N","North","S","South","E","East","W","West","Unknown")
Math & Statisticsintermediate
Measure data spread with STDEV
=STDEV(B2:B100)
Conditional Logicbeginner
Nested IF grade scale
=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))
Date & Timebeginner
NETWORKDAYS for project timeline planning
=NETWORKDAYS(B2,C2)
Data Cleaningbeginner
Remove extra spaces from text with TRIM
=TRIM(A2)
Data Cleaningbeginner
Remove non-printable characters with CLEAN
=CLEAN(A2)
Text Manipulationbeginner
Replace specific text with SUBSTITUTE
=SUBSTITUTE(A2,"-","")
Array Formulasadvanced
Reuse calculations in one formula with LET
=LET(rate,B1/12,periods,B2*12,PMT(rate,periods,-B3))
Date & Timebeginner
Show the day name from a date with TEXT
=TEXT(A2,"DDDD")
Array Formulasbeginner
Sort a range dynamically with SORT
=SORT(A2:B20,2,-1)
Math & Statisticsintermediate
SUMIFS for monthly revenue by category
=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))
Data Cleaningbeginner
Suppress formula errors with IFERROR
=IFERROR(VLOOKUP(A2,$F$2:$G$20,2,FALSE),"-")
Text Manipulationbeginner
TEXTJOIN a column into one cell
=TEXTJOIN(", ",TRUE,A2:A20)
Text Manipulationbeginner
TEXTJOIN for full name building
=TEXTJOIN(" ",TRUE,A2:C2)
Lookup & Referenceadvanced
Two-way lookup with INDEX and MATCH
=INDEX(B2:E10,MATCH(H2,A2:A10,0),MATCH(H3,B1:E1,0))
Data Cleaningbeginner
Validate numeric entries with ISNUMBER
=ISNUMBER(A2)
Lookup & Referenceintermediate
VLOOKUP to match two columns
=VLOOKUP(A2,$F$2:$G$8,2,FALSE)
Lookup & Referenceintermediate
XLOOKUP for the last matching value
=XLOOKUP(A2,$F$2:$F$20,$G$2:$G$20,"Not found",0,-1)