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 | | |