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

**Add business days to a date changing the days of the weekend** | Date - Add or Subtract |

**Add business days to a date excluding public holidays** | Date - Add or Subtract |

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

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

**Add days to a date excluding weekends and changing the days of the weekend** | Date - Add or Subtract |

**Add days to a date excluding weekends and public holidays** | Date - Add or Subtract |

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

**Add days to a date including weekends and public holidays** | Date - Add or Subtract |

**Add days to a date not landing on a weekend** | 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 seconds to a time** | Time - Add or Subtract |

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

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

**Add working days to a date changing the days of the weekend** | Date - Add or Subtract |

**Add working days to a date excluding public holidays** | 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 last n 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 not text** | 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 dates between 2 dates** | Counting - Contain |

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

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

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

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

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

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

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

**Count cells that contain numbers greater than a value** | Counting - Contain |

**Count cells that contain numbers less than a value** | 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 odd numbers** | Counting - Contain |

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

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

**Count cells that contain text of a certain length** | Counting - Contain |

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

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

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

**Count cells that contain unique text strings with 1 condition** | Counting - Conditional |

**Count cells that contain unique values** | 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 errors** | Counting - Contain |

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

**Count cells that do not contain any numbers or text** | 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 |

**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 last entry in a column** | 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 |

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

**Number of business days** | Date - Number of Days |

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

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

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

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

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

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

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

**Number of days between 2 dates excluding weekends** | 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 mondays between 2 dates** | Date - Number of Days |

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

**Number of occurrences of a particular day of the week** | 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 working days** | Date - Number of |

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

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

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

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

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

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

**Number of working hours between 2 dates** | Time - Number of |

**Number of working hours between 2 times** | Time - 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 date in a particular format** | Date - Display |

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

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

**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 numbers to the nearest fraction** | Number - Display |

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

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

**Return the 3rd monday in a month** | Date - Display |

**Return the business days** | Date - Display |

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

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

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

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

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

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

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

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

**Return the date of the monday in the current week** | Date - Display |

**Return the day from date** | Date - Return |

**Return the day name** | Date - Display |

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

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

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

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

**Return the first monday of the next month** | Date - First |

**Return the first monday of the previous month** | Date - First |

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

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

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

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

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

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

**Return the last monday of the next month** | Date - Last |

**Return the last monday of the previous month** | Date - Last |

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

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

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

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

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

**Return the month from date** | Date - Return |

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

**Return the next business day** | Date - Display |

**Return the next working day** | Date - Display |

**Return the nth day of the year** | Date - Return |

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

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

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

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

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

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

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

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

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

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

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

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

**Return the working hours between 2 dates** | Time - Display |

**Return the working hours between 2 times** | Time - Display |

**Return the year from date** | Date - Return |

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

**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 last n numbers** | Summing - Other |

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

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

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

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

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

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

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

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

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