List of Excel

Formula Examples

Search our ever-growing formula list to find the formula example that meets your needs, download Excel example files, or…

Try our Excel Formula Generator:

Generate Formulas

Excel Formula Examples
Date	yes
Add (Subtract) Days to a Date
Concatenate Dates
Convert Date to Number
Convert Date to Text
Month Name to Number
Create Date Range from Dates
Day Number of Year
Month Name from Date
First Day of Month
Add (Subtract) Weeks to a Date
If Functions with Dates
Max Date
Number of Days Between Dates
Number of Days in a Month
Number of Weeks Between Dates
Number of Years Between Dates
Split Date & Time into Separate Cells
Countdown Remaining Days
Insert Dates
Random Date Generator
Using Dynamic Ranges - Year to Date Values
Add (Subtract) Years to a Date
Date Formula Examples
Extract Day from Date
Get Day Name from Date
Count Days Left in Month / Year
Count Workdays Left in Month / Year
Get Last Day of Month
Last Business Day of Month / Year
Number of Work / Business Days in Month
Weekday Abbreviations
Auto Populate Dates
Number of Months Between Dates
Quarter from a Date
Years of Service
Change Date Format
Compare Dates
Time	yes
Add (Subtract) Hours to Time
Add (Subtract) Minutes to Time
Add (Subtract) Seconds to Time
Add Up time (Total Time)
Time Differences
Change Time Format
Convert Minutes to Hours
Convert Time to Decimal
Convert Time to Hours
Convert Time to Minutes
Convert Time to Seconds
Military Time
Round Time to Nearest 15 Minutes
Overtime Calculator
Number of Hours Between Times
Convert Seconds to Minutes, Hours, or Time
Count Hours Worked
Time Differences
Time Format - Show Minutes Seconds
Text	yes
Add Commas to Cells
Get First Word from Text
Capitalize First Letter
Clean & Format Phone #s
Remove Extra Trailing / Leading Spaces
Add Spaces to Cell
Assign Number Value to Text
Combine Cells with Comma
Combine First and Last Names
Convert Text String to Date
Convert Text to Number
Extract Text From Cell
Get Last Word
Remove Unwated Characters
Extract Text Before or After Character
How to Split Text String by Space, Comma, & More
Remove Special Characters
Remove First Characters from Left
Substitute Multiple Values
Switch First & Last Names w/ Commas
Remove Specific Text from a Cell
Extract Text Between Characters (Ex. Parenthesis)
Add Leading Zeros to a Number
Remove Line Breaks from Text
Remove all Numbers from Text
Reverse Text
Remove Non-Numeric Characters
Remove Last Character(s) From Right
Separate First and Last Names
Separate Text & Numbers
Round	yes
Round Formulas
Round Price to Nearest Dollar or Cent
Round to Nearest 10, 100, or 1000
Round to Nearest 5 or .5
Round Percentages
Round to Significant Figures
Count	yes
Count Blank and Non-blank Cells
Count Cells Between Two Numbers
Count Cells not Equal to
Count if Cells are in Range
Count Times Word Appears in Cell
Count Words in Cell

Count Specific Characters in Column
Count Total Number of Characters in Column
Count Cells that Equal one of two Results
Count Cells that do not Contain
Count Cells that Contain Specific Text
Count Unique Values in Range
Countif - Multiple Criteria
Count Total Number of Cells in Range
Count Cells with Any Text
Count Total Cells in a Table
Lookup	yes
Two Dimensional VLOOKUP
VLOOKUP Simple Example
Vlookup - Multiple Matches
Case Sensitive Lookup
Case Sensitive VLOOKUP
Sum if - VLOOKUP
Case Sensitive Lookup
Case Sensitive VLOOKUP
Find Duplicates w/ VLOOKUP or MATCH

INDEX MATCH MATCH
Lookup - Return Cell Address (Not Value)
Lookup Last Value in Column or Row
Reverse VLOOKUP (Right to Left)
Risk Score Bucket with VLOOKUP
Sum with a VLOOKUP Function
VLOOKUP & INDIRECT
VLOOKUP Concatenate
VLOOKUP Contains (Partial Match)
17 Reasons Why Your XLOOKUP is Not Working
Double (Nested) XLOOKUP - Dynamic Columns
IFERROR (& IFNA) XLOOKUP
Lookup Min / Max Value
Nested VLOOKUP
Top 11 Alternatives to VLOOKUP (Updated 2022!)
VLOOKUP – Dynamic Column Reference
VLOOKUP – Fix #N/A Error
VLOOKUP – Multiple Sheets at Once
VLOOKUP & HLOOKUP Combined
VLOOKUP & MATCH Combined
VLOOKUP Between Worksheets or Spreadsheets
VLOOKUP Duplicate Values
VLOOKUP Letter Grades
VLOOKUP Return Multiple Columns
VLOOKUP Returns 0? Return Blank Instead
VLOOKUP w/o #N/A Error
XLOOKUP Multiple Sheets at Once
XLOOKUP Between Worksheets or Spreadsheets
XLOOKUP by Date
XLOOKUP Duplicate Values
XLOOKUP Multiple Criteria
XLOOKUP Return Multiple Columns
XLOOKUP Returns 0? Return Blank Instead
XLOOKUP Text
XLOOKUP with IF
XLOOKUP With If Statement
Misc.	yes
Sort Multiple Columns
Use Cell Value in Formula
Percentage Change Between Numbers
Percentage Breakdown
Rank Values
Add Spaces to Cell
CAGR Formula
Average Time
Decimal Part of Number
Integer Part of a Number
Compare Items in a List
Dealing with NA() Errors
Get Worksheet Name
Wildcard Characters
Hyperlink to Current Folder
Compound Interest Formula
Percentage Increase
Create Random Groups
Sort with the Small and Large Functions
Non-volatile Function Alternatives
Decrease a Number by a Percentage
Calculate Percent Variance
Profit Margin Calculator
Convert Column Number to Letter
Get Full Address of Named Range
Insert File Name
Insert Path
Latitute / Longitude Functions
Replace Negative Values
Reverse List Range

Convert State Name to Abbreviation
Create Dynamic Hyperlinks
Custom Sort List with Formula
Data Validation - Custom Formulas
Dynamic Sheet Reference (INDIRECT)
Reference Cell in Another Sheet or Workbook
Get Cell Value by Address
Get Worksheet Name
Increment Cell Reference
List Sheet Names
List Skipped Numbers in Sequence
Return Address of Max Value in Range
Search by Keywords
Select Every Other (or Every nth) Row
Basics	yes
Cell Reference Basics - A1, R1C1, 3d, etc.
Add Up (Sum) Entire Column or Row
Into to Dynamic Array Formulas
Conversions	yes
Convert Time Zones
Convert Celsius to Fahrenheit
Convert Pounds to Kilograms
Convert Time to Unix Time
Convert Feet to Meters
Convert Centimeters to Inches
Convert Kilometers to Miles
Convert Inches to Feet
Convert Date to Julian Format
Convert Column Letter to Number
Tests	yes
Test if a Range Contains any Text
Test if any Cell in Range is Number
Test if a Cell Contains a Specific Value


Test if Cell Contains Any Number
Test if Cell Contains Specific Number
Test if Cell is Number or Text
If	yes
Percentile If
Subtotal If
Sumproduct If
Large If and Small If
Median If
Concatentate If
Max If
Rank If
TEXTJOIN If
Sum	yes
Sum if - Begins With / Ends With
Sum if - Month or Year to Date
Sum if - By Year
Sum if - Blank / Non-Blank
Sum if - Horizontal Sum
Count / Sum If - Cell Color
INDIRECT Sum
Sum If - Across Multiple Sheets
Sum If - By Month
Sum If - Cells Not Equal To
Sum If - Not Blank
Sum if - Between Values
Sum If - Week Number
Sum Text
Sum if - By Category or Group
Sum if - Cell Contains Specific Text (Wildcards)
Sum if - Date Rnage
Sum if - Dates Equal
Sum if - Day of Week
Sum if - Greater Than
Sum if - Less Than
Average	yes
Average Non-Zero Values
Average If - Not Blank
Average - Ignore 0
Average - Ignore Errors
Math	yes
Multiplication Table
Cube Roots
nth Roots
Square Numbers
Square Roots
Calculations	yes
Calculate a Ratio
Calculate Age
Calculate Loan Payments
GPA Formula
Calculate VAT Tax
How to Grade Formulas
Find	yes
Find a Number in a Column / Workbook
Find Most Frequent Numbers
Find Smallest n Values
Find nth Occurance of Character in Text
Find and Extract Number from String
Find Earliest or Latest Date Based on Criteria
Find First Cell with Any Value
Find Last Row
Find Last Row with Data
Find Missing Values
Find Largest n Values
Most Frequent Number
Conditional Formatting	yes
Conditional Format - Dates & Times
Conditional Format - Highlight Blank Cells