List of Excel

Formula Examples

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

Excel Formula Examples 
Add (Subtract) Days to a Date
Add (Subtract) Weeks to a Date
Add (Subtract) Years to a Date
Auto Populate Dates
Number of Months Between Dates
Quarter from a Date
Years of Service
Change Date Format
Compare Dates
Concatenate Dates
Conditionally Format Dates & Times
Convert Date to Number
Convert Date to Text
Month Name to Number
Create Date Range from Dates
Day Number of Year
Current Quarter of Year
Month Name from Date
First Day of Month
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
Year To Date with Dynamic Ranges
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 Number
Convert Time to Seconds
Military Time
Round Time to Nearest 15 Minutes
Round Formulas
Round Price to Nearest Dollar or Cent
Round to Nearest 10, 100, or 1000
Round to Nearest 5 or .5
Two Dimensional VLOOKUP
VLOOKUP Multiple Matches
VLOOKUP Simple Example
Add Spaces to Cell
Average non-zero values
CAGR Formula
Average Time
Decimal Part of Number
Integer Part of a Number
Percentage Change Between Numbers
Compare Items in a List
Dealing with NA() Errors
Get Worksheet Name
Retrieve First Word
If Cell Contains Specific Text
Wildcard Characters
Hyperlink to Current Folder
Latitute Longitude Functions
Percentage Increase
Ranking Values