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 | | |
| |  |
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 | |  |
| |  |
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 | |  |
| |  |
| |  |
Remove Unwated Characters | |  |
| |  |
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 | |  |
| |  |
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 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 | |  |