List of Excel

Formula Examples

Search our ever-growing formula list to find the formula example that meets your needs.

Excel Formula Examples  
Dateyes
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 Generatorrandom date generator example download
Using Dynamic Ranges - Year to Date Values
Add (Subtract) Years to a Date
Date Formula Examples
Extract Day from Dateextract day from date example download
Get Day Name from Dateday name from date example download
Count Days Left in Month / Yeardays left month year example download
Count Workdays Left in Month / Yearworkdays left month year example download
Get Last Day of Monthlast day of month example download
Last Business Day of Month / Yearlast business day month year example download
Number of Work / Business Days in Monthworkdays in month example download
Weekday Abbreviationsweekday abbreviations example download
Auto Populate Dates
Number of Months Between Dates
Quarter from a Date
Years of Service
Change Date Format
Compare Dates
Timeyes
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 Timescalculate hours between times example download
Convert Seconds to Minutes, Hours, or Timeconvert seconds to minutes hours example download
Count Hours Workedcalculate hours worked example download
Time Differencestime difference hours minutes seconds example download
Time Format - Show Minutes Secondstime format show minutes seconds example download
Textyes
Add Commas to Cellsadd comma example download
Get First Word from Text
Capitalize First Lettercapitalize first letter example download
Clean & Format Phone #sclean format phone numbers example download
Remove Extra Trailing / Leading Spacesremove extra trailing leading spaces example download
Add Spaces to Celladd spaces to cell example download
Assign Number Value to Textassign number value to text example download
Combine Cells with Commacombine cells comma example download
Combine First and Last Namescombine first last names example download
Convert Text String to Dateconvert text to date example download
Convert Text to Numberconvert text number example download
Extract Text From Cellextract text from cell example download
Get Last Word
Remove Unwated Charactersremove unwanted characters example download
Extract Text Before or After Characterextract text before after character example download
How to Split Text String by Space, Comma, & Moresplit text space comma example download
Remove Special Characters
Remove First Characters from Leftremove first chars from left example download
Substitute Multiple Valuessubstitute multiple values example download
Switch First & Last Names w/ Commasswitch first last names commas example download
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
Roundyes
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
Countyes
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 Cellcount times word appears in cell example download
Count Words in Cellcount words in cell example download
Count Specific Characters in Columncount specific characters column example download
Count Total Number of Characters in Columncount total characters column example download
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
Lookupyes
Two Dimensional VLOOKUP
VLOOKUP Simple Example
Vlookup - Multiple Matches
Case Sensitive Lookup
Case Sensitive VLOOKUP
Sum if - VLOOKUPsum if vlookup example download
Case Sensitive Lookupcase sensitive lookup example download
Case Sensitive VLOOKUPvlookup case sensitive example download
Find Duplicates w/ VLOOKUP or MATCHfind duplicates vlookup match example download
INDEX MATCH MATCHindex match match 2d lookup example download
Lookup - Return Cell Address (Not Value)
Lookup Last Value in Column or Rowlookup last value column example download
Reverse VLOOKUP (Right to Left)reverse vlookup right to left example download
Risk Score Bucket with VLOOKUPrisk score bucket vlookup example download
Sum with a VLOOKUP Functionsum vlookup example download
VLOOKUP & INDIRECTvlookup indirect example download
VLOOKUP Concatenatevlookup concatenate example download
VLOOKUP Contains (Partial Match)vlookup contains partial match example download
Misc.yes
Sort Multiple Columnssort two columns example download
Use Cell Value in Formulause cell value in formula example download
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() Errorsif isna vlookup example download
Get Worksheet Name
Wildcard Characters
Hyperlink to Current Folderhyperlink to current folder example download
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 Letterconvert column number to letter example download
Get Full Address of Named Range
Insert File Nameinsert file name formula example download
Insert Pathinsert path formula example download
Latitute / Longitude Functions
Replace Negative Values
Reverse List Rangereverse list range example download
Convert State Name to Abbreviationconvert state name abbreviation example download
Create Dynamic Hyperlinksdynamic hyperlinks example download
Custom Sort List with Formulacustom sort list example download
Data Validation - Custom Formulas
Dynamic Sheet Reference (INDIRECT)indirect dynamic sheet example download
Reference Cell in Another Sheet or Workbookreference cell in another sheet workbook example download
Get Cell Value by Addressget cell value by address row column example download
Get Worksheet Nameget sheet name example download
Increment Cell Referenceincrement cell reference example download
List Sheet Names
List Skipped Numbers in Sequencelist skipped numbers in sequence example download
Return Address of Max Value in Rangereturn address highest value in range example download
Search by Keywordssearch by keywords example download
Select Every Other (or Every nth) Row
Basicsyes
Cell Reference Basics - A1, R1C1, 3d, etc.
Add Up (Sum) Entire Column or Row
Into to Dynamic Array Formulas
Conversionsyes
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 Numberconvert column letter to number example download
Testsyes
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 Numberif cell contains any number example download
Test if Cell Contains Specific Numberif cell contains number example download
Test if Cell is Number or Textcell is number text example download
Ifyes
Percentile If
Subtotal If
Sumproduct If
Large If and Small If
Median If
Concatentate Ifconcatenate if example download
Max Ifmax if with condition example download
Rank Ifrank if example download
TEXTJOIN Iftextjoin if example download
Sumyes
Sum if - Begins With / Ends Withsum if begins ends with example download
Sum if - Month or Year to Datesum if month year to date example download
Sum if - By Yearsum if year example download
Sum if - Blank / Non-Blanksum if blank example download
Sum if - Horizontal Sumsum if horizontal example download
Count / Sum If - Cell Color
INDIRECT Sumindirect sum example download
Sum If - Across Multiple Sheetssum if multiple sheets example download
Sum If - By Monthsum if month example download
Sum If - Cells Not Equal Tosum if not equal example download
Sum If - Not Blanksum if not blank example download
Sum if - Between Valuessum if between values example download
Sum If - Week Numbersum if week number example download
Sum Textsum text example download
Sum if - By Category or Groupsum if category group example download
Sum if - Cell Contains Specific Text (Wildcards)sum if contains text wildcards example download
Sum if - Date Rnagesum if date range example download
Sum if - Dates Equalsum if dates equal example download
Sum if - Day of Weeksum if day of week example download
Sum if - Greater Thansum if greater than example download
Sum if - Less Thansum if less than example download
Averageyes
Average Non-Zero Values
Average If - Not Blankaverage if not blank example download
Average - Ignore 0average ignore 0 example download
Average - Ignore Errorsaverage ignore errors example download
Mathyes
Multiplication Table
Cube Rootscube root example download
nth Rootsnth root example download
Square Numberssquare numbers example download
Square Rootssquare roots example download
Calculationsyes
Calculate a Ratio
Calculate Age
KILLLLLLL
Calculate Loan Payments
GPA Formulagpa formula example download
Calculate VAT Taxcalculate vat tax example download
How to Grade Formulasgrade formulas example download
Findyes
Find a Number in a Column / Workbookfind number in column example download
Find Most Frequent Numbersfind most frequent numbers example download
Find Smallest n Values
Find nth Occurance of Character in Text
Find and Extract Number from Stringfind extract number from string example download
Find Earliest or Latest Date Based on Criteriafind earliest latest date with criteria example download
Find First Cell with Any Valuefind first cell with any value example download
Find Last Rowfind last row example download
Find Last Row with Datafind last row with data example download
Find Missing Valuesfind missing values example download
Find Largest n Values
Most Frequent Numberfind most frequent numbers example download
Conditional Formattingyes
Conditional Format - Dates & Times
Conditional Format - Highlight Blank Cells