**Add days to a date** | Date - Add or Subtract |

**Add days to a date avoiding weekends** | Date - Add or Subtract |

**Add hours to a time** | Time - Add or Subtract |

**Add minutes to a time** | Time - Add or Subtract |

**Add months to a date** | Date - Add or Subtract |

**Add workdays to a date** | Date - Add or Subtract |

**Add years to a date** | Date - Add or Subtract |

**Average cells after subtraction** | Number - Average |

**Average cells that contain numbers** | Number - Average |

**Average cells that contain numbers ignoring duplicates** | Number - Average |

**Average cells that contain numbers ignoring zeros** | Number - Average |

**Average cells that contain numbers weighted average** | Number - Average |

**Average numbers** | Number - Average |

**Average the n largest numbers** | Number - Average |

**Average the n smallest numbers** | Number - Average |

**Convert a date string to a date value** | Date - Convert |

**Convert a number into currency format** | Number - Convert |

**Convert hours to a time** | Time - Convert |

**Convert minutes to a time** | Time - Convert |

**Convert numbers to text** | Text - Convert |

**Convert seconds to a time** | Time - Convert |

**Convert text to numbers** | Text - Convert |

**Convert time to time zone** | Time - Convert |

**Count cells between 2 dates** | Counting - Between |

**Count cells between 2 numbers** | Counting - Between |

**Count cells equal to 1 value** | Counting - Equal To |

**Count cells equal to 1 value case sensitive** | Counting - Equal To |

**Count cells equal to 2 values** | Counting - Equal To |

**Count cells equal to 3 or more values** | Counting - Equal To |

**Count cells equal to either x or y** | Counting - Equal To |

**Count cells equal to one of many** | Counting - Equal To |

**Count cells greater than a value** | Counting - Less Than or Greater Than |

**Count cells less than a value** | Counting - Less Than or Greater Than |

**Count cells not equal to 1 value** | Counting - Not Equal To |

**Count cells not equal to 1 value case sensitive** | Counting - Not Equal To |

**Count cells not equal to 2 values** | Counting - Not Equal To |

**Count cells not equal to 3 or more values** | Counting - Not Equal To |

**Count cells not equal to either x or y** | Counting - Not Equal To |

**Count cells that are a number of characters long** | Counting - Contain |

**Count cells that are blank** | Counting - Equal To |

**Count cells that are errors** | Counting - Contain |

**Count cells that are even numbers** | Counting - Contain |

**Count cells that are negative numbers** | Counting - Contain |

**Count cells that are not blank** | Counting - Not Equal To |

**Count cells that are not equal to either x or y** | Counting - Are |

**Count cells that are not equal to one of many** | Counting - Are |

**Count cells that are not errors** | Counting - Not Equal To |

**Count cells that are numbers** | Counting - Are |

**Count cells that are odd numbers** | Counting - Are |

**Count cells that are positive numbers** | Counting - Are |

**Count cells that are text** | Counting - Are |

**Count cells that are unique numbers** | Counting - Are |

**Count cells that are unique text strings** | Counting - Are |

**Count cells that are unique text strings with 1 condition** | Counting - Are |

**Count cells that begin with** | Counting - Contain |

**Count cells that contain 1 text string** | Counting - Contain |

**Count cells that contain 2 text strings** | Counting - Contain |

**Count cells that contain either x or y** | Counting - Contain |

**Count cells that contain errors** | Counting - Contain |

**Count cells that contain n characters** | Counting - Contain |

**Count cells that contain numbers** | Counting - Contain |

**Count cells that contain numbers with 1 condition** | Counting - Conditional |

**Count cells that contain numbers with multiple conditions** | Counting - Conditional |

**Count cells that contain text** | Counting - Contain |

**Count cells that do not begin with** | Counting - Contain |

**Count cells that do not contain a text string** | Counting - Contain |

**Count cells that do not contain any numbers** | Counting - Contain |

**Count cells that do not end with** | Counting - Contain |

**Count cells that end with** | Counting - Contain |

**Count cells that meet either condition** | Counting - Conditional |

**Count cells with formatting** | Counting - Conditional |

**Count cells with shading** | Counting - Conditional |

**Count columns with multiple OR criteria** | Counting - Other |

**Count differences between 2 cell ranges** | Counting - Conditional |

**Count hidden rows** | Counting - Other |

**Count hidden rows in a filtered column** | Counting - Other |

**Count hidden rows with 1 condition** | Counting - Other |

**Count hidden rows with multiple conditions** | Counting - Other |

**Count if items are in a list** | Counting - Other |

**Count if row meets internal criteria** | Counting - Other |

**Count if row meets multiple internal criteria** | Counting - Other |

**Count if two criteria match** | Counting - Other |

**Count matches between 2 columns** | Counting - Other |

**Count rows with multiple OR criteria** | Counting - Other |

**Count substring occurrences** | Counting - Other |

**Count total characters in range** | Counting - Other |

**Count total matches in 2 ranges** | Counting - Other |

**Count unique numbers** | Counting - Other |

**Count unique numbers with 1 condition** | Counting - Other |

**Count unique text strings** | Counting - Other |

**Count unique text strings with 1 condition** | Counting - Other |

**Count unique values** | Counting - Other |

**Count visible rows** | Counting - Other |

**Count visible rows in a filtered column** | Counting - Other |

**Count visible rows with 1 condition** | Counting - Other |

**Count visible rows with multiple conditions** | Counting - Other |

**Display a date in a particular format** | Date - Display |

**Display a date in US date format** | Date - Display |

**Display a persons age in years** | Date - Display |

**Display numbers to the nearest fraction** | Number - Display |

**Display random characters** | Text - Display |

**Display random numbers between 1 and 25** | Number - Display |

**Display the 3rd Monday in a month** | Date - Display |

**Display the current date** | Date - Display |

**Display the current date and time** | Date - Display |

**Display the current day** | Date - Display |

**Display the current month** | Date - Display |

**Display the current quarter** | Date - Display |

**Display the current time** | Time - Display |

**Display the current year** | Date - Display |

**Display the date from date and time** | Date - Display |

**Display the date of the Monday in the current week** | Date - Display |

**Display the day of the week occurrence** | Date - Display |

**Display the number corresponding to a given month** | Date - Display |

**Display the percentage change** | Number - Display |

**Display the time elapsed between 2 times** | Time - Display |

**Display the time from date and time** | Time - Display |

**Display the time rounded to the nearest 15 minutes** | Time - Display |

**Display the week number of the current date** | Date - Display |

**Display two strings joined together** | Text - Display |

**Display work hours between 2 dates** | Time - Display |

**Find a matching value** | Lookup - Find |

**Find a matching value case sensitive** | Lookup - Find |

**Find a matching value cross reference** | Lookup - Find |

**Find a matching value in any column** | Lookup - Find |

**Find a matching value in first column** | Lookup - Find |

**Find a partial match** | Lookup - Find |

**Find a particular occurrence** | Lookup - Find |

**Find the cell address of the largest number** | Other - Other |

**Find the closest match** | Lookup - Find |

**Find the largest number** | Lookup - Find |

**Find the largest number with 1 condition** | Lookup - Find |

**Find the largest number with multiple conditions** | Lookup - Find |

**Find the n largest numbers** | Lookup - Find |

**Find the n smallest numbers** | Lookup - Find |

**Find the nth largest number** | Lookup - Find |

**Find the nth largest number with 1 condition** | Lookup - Find |

**Find the nth match** | Lookup - Find |

**Find the nth smallest number** | Lookup - Find |

**Find the nth smallest number with 1 condition** | Lookup - Find |

**Find the position of the active worksheet in the workbook** | Other - Other |

**Find the row of the largest number** | Other - Other |

**Find the smallest number** | Lookup - Find |

**Find the smallest number with 1 condition** | Lookup - Find |

**Find the smallest number with multiple conditions** | Lookup - Find |

**Find the unique values in a range** | Lookup - Find |

**First day of the current month** | Date - First |

**First day of the previous month** | Date - First |

**First Monday of the next month** | Date - First |

**First Monday of the previous month** | Date - First |

**First weekday of the year** | Date - First |

**Last day of the current month** | Date - Last |

**Last day of the previous month** | Date - Last |

**Last Monday of the next month** | Date - Last |

**Last Monday of the previous month** | Date - Last |

**Last weekday of the year** | Date - Last |

**Multiply numbers and sum** | Summing - Other |

**Number of days between 2 dates** | Date - Number of Days |

**Number of days in a particular month** | Date - Number of Days |

**Number of days in a particular year** | Date - Number of Days |

**Number of days left in the current month** | Date - Number of Days |

**Number of days left in the current year** | Date - Number of Days |

**Number of days that have passed in the current month** | Date - Number of Days |

**Number of days that have passed in the current year** | Date - Number of Days |

**Number of months between 2 dates** | Date - Number of Months |

**Number of weekdays** | Date - Number of |

**Number of weekdays between 2 dates** | Date - Number of |

**Number of weekdays in a particular month** | Date - Number of |

**Number of weekdays left in the current month** | Date - Number of |

**Number of weekdays left in the current year** | Date - Number of |

**Number of weekdays that have passed in the current month** | Date - Number of |

**Number of weekdays that have passed in the current year** | Date - Number of |

**Number of weekend days** | Date - Number of |

**Number of weekend days between 2 dates** | Date - Number of |

**Number of weekend days in a particular month** | Date - Number of |

**Number of weekend days in a particular year** | Date - Number of |

**Number of years between 2 dates** | Date - Number of Years |

**Only allow a certain number of characters** | Data Validation - Only allow |

**Only allow characters in uppercase** | Data Validation - Only allow |

**Only allow dates in a particular range** | Data Validation - Only allow |

**Only allow dates that are weekdays** | Data Validation - Only allow |

**Only allow dates that are weekends** | Data Validation - Only allow |

**Only allow entries in a particular format** | Data Validation - Only allow |

**Only allow numbers** | Data Validation - Only allow |

**Only allow numbers in a particular range** | Data Validation - Only allow |

**Only allow percentages** | Data Validation - Only allow |

**Only allow text** | Data Validation - Only allow |

**Only allow times** | Data Validation - Only allow |

**Only allow unique values no duplicates** | Data Validation - Only allow |

**Only allow values whose sum is restricted** | Data Validation - Only allow |

**Only allow yes or no** | Data Validation - Only allow |

**Remove last n characters** | Text - Remove |

**Remove one word** | Text - Remove |

**Remove unwanted characters** | Text - Remove |

**Replace one character with another** | Text - Replace |

**Replace one word with another** | Text - Replace |

**Replace text by matching** | Text - Replace |

**Replace text by position** | Text - Replace |

**Return a substring** | Text - Return |

**Return all numbers reduced by 10 percent** | Number - Return |

**Return an array of worksheet names** | Other - Other |

**Return every fourth entry in a list** | Text - Return |

**Return the decimal part of a number** | Number - Return |

**Return the digits in reverse order** | Number - Return |

**Return the first name from full name** | Text - Return |

**Return the first word** | Text - Return |

**Return the integer part of a number** | Number - Return |

**Return the last name from full name** | Text - Return |

**Return the last word** | Text - Return |

**Return the longest string in a column** | Text - Return |

**Return the middle name from full name** | Text - Return |

**Return the most frequently occurring word** | Text - Return |

**Return the nth word** | Text - Return |

**Return the number from a number and text** | Text - Return |

**Return the text converted to sentence case** | Text - Return |

**Return the value from the cell above** | Text - Return |

**Return the words in reverse order** | Text - Return |

**Return the workbook name from a full path** | Other - Other |

**Round a number down** | Number - Round |

**Round a number down to a nearest multiple** | Number - Round |

**Round a number to n significant figures** | Number - Round |

**Round a number to nearest 100** | Number - Round |

**Round a number to nearest 5** | Number - Round |

**Round a number up** | Number - Round |

**Round a number up to a nearest multiple** | Number - Round |

**Shade cells between 2 dates** | Formatting - Shade all |

**Shade cells between 2 numbers** | Formatting - Shade all |

**Shade cells in a particular row** | Formatting - Shade all |

**Shade cells in alternate rows** | Formatting - Shade all |

**Shade cells that are blank** | Formatting - Shade all |

**Shade cells that are errors** | Formatting - Shade all |

**Shade cells that are even numbers** | Formatting - Shade all |

**Shade cells that are negative numbers** | Formatting - Shade all |

**Shade cells that are not errors** | Formatting - Shade all |

**Shade cells that are numbers** | Formatting - Shade all |

**Shade cells that are odd numbers** | Formatting - Shade all |

**Shade cells that are positive numbers** | Formatting - Shade all |

**Shade cells that contain a text string** | Formatting - Shade all |

**Shade cells that contain numbers** | Formatting - Shade all |

**Shade cells that do not contain a text string** | Formatting - Shade all |

**Shade cells with dates equal to a value** | Formatting - Shade all |

**Shade cells with dates in the next n days** | Formatting - Shade all |

**Shade cells with duplicate rows** | Formatting - Shade all |

**Shade cells with duplicate values** | Formatting - Shade all |

**Shade cells with formatting** | Formatting - Shade all |

**Shade dates greater than a value** | Formatting - Shade all |

**Shade dates less than a value** | Formatting - Shade all |

**Shade dates that are weekdays** | Formatting - Shade all |

**Shade dates that are weekends** | Formatting - Shade all |

**Shade items in a list** | Formatting - Shade all |

**Shade positive changes** | Formatting - Shade all |

**Subtract days from a date** | Date - Add or Subtract |

**Subtract months from a date** | Date - Add or Subtract |

**Subtract years from a date** | Date - Add or Subtract |

**Sum across worksheets** | Summing - Other |

**Sum across worksheets with 1 condition** | Summing - Other |

**Sum all the individual digits of a number** | Summing - Other |

**Sum by group** | Summing - Other |

**Sum by month** | Summing - Other |

**Sum cells after multiplying** | Summing - Other |

**Sum cells between 2 dates** | Summing - Between |

**Sum cells between 2 numbers** | Summing - Between |

**Sum cells equal to 2 values** | Summing - Equal To |

**Sum cells equal to 3 or more values** | Summing - Equal To |

**Sum cells equal to a value** | Summing - Equal To |

**Sum cells equal to a value case sensitive** | Summing - Equal To |

**Sum cells greater than a value** | Summing - Less Than or Greater Than |

**Sum cells less than a value** | Summing - Less Than or Greater Than |

**Sum cells not equal to blank** | Summing - Not Equal To |

**Sum cells not equal to errors** | Summing - Not Equal To |

**Sum cells that begin with** | Summing - Contain |

**Sum cells that contain a text string** | Summing - Contain |

**Sum cells that contain a unique text string** | Summing - Other |

**Sum cells that contain even numbers** | Summing - Contain |

**Sum cells that contain n characters** | Summing - Other |

**Sum cells that contain negative numbers** | Summing - Contain |

**Sum cells that contain numbers** | Summing - Other |

**Sum cells that contain numbers with 1 condition** | Summing - Conditional |

**Sum cells that contain numbers with multiple conditions** | Summing - Conditional |

**Sum cells that contain odd numbers** | Summing - Contain |

**Sum cells that contain positive numbers** | Summing - Contain |

**Sum cells that contain text** | Summing - Other |

**Sum cells that contain unique numbers** | Summing - Other |

**Sum cells that do not contain a text string** | Summing - No Contain |

**Sum cells that do not contain errors** | Summing - Other |

**Sum cells that end with** | Summing - Contain |

**Sum cells that meet 1 condition** | Summing - Other |

**Sum cells that meet either condition** | Summing - Other |

**Sum cells that meet multiple conditions** | Summing - Other |

**Sum cells using array formula** | Summing - Other |

**Sum cells with formatting** | Summing - Other |

**Sum cells with OR criteria** | Summing - Other |

**Sum cells with shading** | Summing - Other |

**Sum comma delimited numbers** | Summing - Other |

**Sum entire column** | Summing - Other |

**Sum entire row** | Summing - Other |

**Sum every n cells in a column** | Summing - Other |

**Sum every n cells in a range** | Summing - Other |

**Sum every n cells in a row** | Summing - Other |

**Sum numbers** | Summing - Other |

**Sum running total** | Summing - Other |

**Sum the n largest numbers** | Summing - Other |

**Sum the n smallest numbers** | Summing - Other |

**Sum top n largest numbers** | Summing - Other |

**Sum top n smallest numbers** | Summing - Other |

**Test if a substring exists** | Conditional - If |

**Test if cell contains 1 text string** | Conditional - If |

**Test if cell is between 2 numbers** | Conditional - If |

**Test if cell is blank** | Conditional - If |

**Test if cell is greater than 1 value** | Conditional - If |

**Test if cell is not blank** | Conditional - If |

**Test if year is a leap year** | Date - Test |