User Defined Functions Complete List

ALLSHEETS	Returns the min, max or sum of the identical cells across all worksheets.
AVERAGETOP	Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLEA	Returns the average value from visible, non blank cells in a range (including logical values and text).
BUSDAYDIFF	Returns the number of business days between two dates.
BUSDAYMONTHEND	Returns the last business day in a particular month and year.
BUSDAYMONTHSTART	Returns the first business day in a particular month and year.
BUSDAYNTH	Returns the nth business day in a particular month and year.
BUSDAYSADD	Returns the date after adding or removing a number of business days to or from a date.
BUSDAYYEAREND	Returns the last business day in a particular year.
BUSDAYYEARSTART	Returns the first business day in a particular year.
CELLTYPE	Returns the type of value that is contained in a particular cell.
COLUMNWIDTH	Returns the column width of a particular cell.
COMPUTERNAME	Returns the full computer name.
COUNTTEXTCELLS	Returns the number of cells that contain text.
COUNTVISIBLEA	Returns the number of visible, non blank cells in a range (including logical values and text).
DATEADDTENOR	Returns the date after adding or removing a tenor.
DATEADDYMD	Returns the date after adding or removing a given number of years, months and days.
DATECOUNTFRACTION	Returns the date count fraction between two dates.
DATEFIRST	Returns the date of the first day of a week, month or year.
DATEFREQUENCYTOTENOR	Returns the tenor based on the frequency.
DATEHOLIDAYSGET	Returns the list of holidays between two dates.
DATELAST	Returns the date of the last day of a week, month or year.
DATENEXTIMM	Returns the International Money Market date based on a range.
DATESBEFORE1900	Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY	Returns the date given a month, a week number and a day of the week.
DAYSACCRUAL	Returns the number of accrual days between two dates with a given basis.
EXCELDIR	Returns the various folder locations that Excel uses including installation and startup.
EXTRACTTEXT	Returns only the text from a text string that contains other characters as well.
FINDMATCH	Returns the position of an item in a list.
FIRSTWORD	Returns the first word from a text string.
FOLDEREXISTS	Returns whether a particular folder exists.
IMAGEDISPLAY	Returns an image in the top left corner of the active cell.
INSERTSTRING	Returns the text string with a substring inserted in the middle.
INVERSE	Returns the number divided into 1.
ISBETWEEN	Returns whether a particular cell value is between a range.
ISDATEVALID	Returns whether a particular value is a valid date.
ISDATEBUSDAY	Returns whether a particular value is a valid business day.
ISDATEFIRST	Returns whether a date is the first of a week, month or year.
ISDATELAST	Returns whether a date is the last of a week, month or year.
ISINTEGER	Returns whether a particular cell contains an integer number.
ISITALIC	Returns whether a particular cell has been formatted in italic.
ISLIKE	Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED	Returns whether a particular cell has been locked.
ISLOWER	Returns whether a particular cell has been formatted in lower case.
ISMERGED	Returns whether a particular cell has been merged.
ISPRIME	Returns whether a particular cell contains a prime number.
ISPROPER	Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE	Returns whether a particular cell has been formatted in underline.
ISUPPER	Returns whether a particular cell has been formatted in upper case.
ISWRAPPED	Returns whether a particular cell has been formatted with text wrap.
LASTWORD	Returns the last word from a text string.
MAXBETWEEN	Returns the largest value that is between a range.
MAXVISIBLEA	Returns the largest value from visible, non blank cells in a range (including logical values and text).
MEDIANIFS	Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE	Returns the middle value from visible, non blank cells in a range.
MEDIANVISIBLEIFS	Returns the middle value from visible, non blank cells that satisfies multiple conditions.
MINBETWEEN	Returns the smallest value that is between a range.
MINVISIBLEA	Returns the smallest value from visible, non blank cells in a range (including logical values and text).
NETWORKDAYSMISC	Returns the number of days between two dates using a defined list of workdays.
NONBLANKVALUES	Returns an array of all the non blank items in a range.
NUMBERTOROMAN	Returns the text string converting a binary number to a roman numeral.
ORDINAL	Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS	Returns the percentage of values that satisfy multiple conditions.
PRODUCTVISIBLE	Returns the product of visible non blank cells.
RANDOMNUMBER	Returns a random number between two intervals.
REMOVESPACES	Returns a text string with any spaces removed.
REMOVETEXT	Returns a text string with a substring removed.
ROWHEIGHT	Returns the row height of a particular cell.
SELECTONE	Returns a value at random from a range of cells.
SHEETOFFSET	Returns the contents of a cell on a different worksheet.
SUMBETWEEN	Returns the sum of values that are between a range.
SUMDIGITS	Returns the sum of the digits in a particular cell.
WEEKNUMBER	Returns the week number of a particular date.
WORDCOUNT	Returns the number of words in a particular cell.
WORDGET	Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION	Returns the file extension of the active workbook.
WORKDAY6	Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC	Returns the serial number before or after a given number of days from a start date using a defined list of workdays.

ALLSHEETS Returns the min, max or sum of the identical cells across all worksheets.
AVERAGETOP Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLEA Returns the average value from visible, non blank cells in a range (including logical values and text).
BUSDAYDIFF Returns the number of business days between two dates.
BUSDAYMONTHEND Returns the last business day in a particular month and year.
BUSDAYMONTHSTART Returns the first business day in a particular month and year.
BUSDAYNTH Returns the nth business day in a particular month and year.
BUSDAYSADD Returns the date after adding or removing a number of business days to or from a date.
BUSDAYYEAREND Returns the last business day in a particular year.
BUSDAYYEARSTART Returns the first business day in a particular year.
CELLTYPE Returns the type of value that is contained in a particular cell.
COLUMNWIDTH Returns the column width of a particular cell.
COMPUTERNAME Returns the full computer name.
COUNTTEXTCELLS Returns the number of cells that contain text.
COUNTVISIBLEA Returns the number of visible, non blank cells in a range (including logical values and text).
DATEADDTENOR Returns the date after adding or removing a tenor.
DATEADDYMD Returns the date after adding or removing a given number of years, months and days.
DATECOUNTFRACTION Returns the date count fraction between two dates.
DATEFIRST Returns the date of the first day of a week, month or year.
DATEFREQUENCYTOTENOR Returns the tenor based on the frequency.
DATEHOLIDAYSGET Returns the list of holidays between two dates.
DATELAST Returns the date of the last day of a week, month or year.
DATENEXTIMM Returns the International Money Market date based on a range.
DATESBEFORE1900 Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY Returns the date given a month, a week number and a day of the week.
DAYSACCRUAL Returns the number of accrual days between two dates with a given basis.
EXCELDIR Returns the various folder locations that Excel uses including installation and startup.
EXTRACTTEXT Returns only the text from a text string that contains other characters as well.
FINDMATCH Returns the position of an item in a list.
FIRSTWORD Returns the first word from a text string.
FOLDEREXISTS Returns whether a particular folder exists.
IMAGEDISPLAY Returns an image in the top left corner of the active cell.
INSERTSTRING Returns the text string with a substring inserted in the middle.
INVERSE Returns the number divided into 1.
ISBETWEEN Returns whether a particular cell value is between a range.
ISDATEVALID Returns whether a particular value is a valid date.
ISDATEBUSDAY Returns whether a particular value is a valid business day.
ISDATEFIRST Returns whether a date is the first of a week, month or year.
ISDATELAST Returns whether a date is the last of a week, month or year.
ISINTEGER Returns whether a particular cell contains an integer number.
ISITALIC Returns whether a particular cell has been formatted in italic.
ISLIKE Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED Returns whether a particular cell has been locked.
ISLOWER Returns whether a particular cell has been formatted in lower case.
ISMERGED Returns whether a particular cell has been merged.
ISPRIME Returns whether a particular cell contains a prime number.
ISPROPER Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE Returns whether a particular cell has been formatted in underline.
ISUPPER Returns whether a particular cell has been formatted in upper case.
ISWRAPPED Returns whether a particular cell has been formatted with text wrap.
LASTWORD Returns the last word from a text string.
MAXBETWEEN Returns the largest value that is between a range.
MAXVISIBLEA Returns the largest value from visible, non blank cells in a range (including logical values and text).
MEDIANIFS Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE Returns the middle value from visible, non blank cells in a range.
MEDIANVISIBLEIFS Returns the middle value from visible, non blank cells that satisfies multiple conditions.
MINBETWEEN Returns the smallest value that is between a range.
MINVISIBLEA Returns the smallest value from visible, non blank cells in a range (including logical values and text).
NETWORKDAYSMISC Returns the number of days between two dates using a defined list of workdays.
NONBLANKVALUES Returns an array of all the non blank items in a range.
NUMBERTOROMAN Returns the text string converting a binary number to a roman numeral.
ORDINAL Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS Returns the percentage of values that satisfy multiple conditions.
PRODUCTVISIBLE Returns the product of visible non blank cells.
RANDOMNUMBER Returns a random number between two intervals.
REMOVESPACES Returns a text string with any spaces removed.
REMOVETEXT Returns a text string with a substring removed.
ROWHEIGHT Returns the row height of a particular cell.
SELECTONE Returns a value at random from a range of cells.
SHEETOFFSET Returns the contents of a cell on a different worksheet.
SUMBETWEEN Returns the sum of values that are between a range.
SUMDIGITS Returns the sum of the digits in a particular cell.
WEEKNUMBER Returns the week number of a particular date.
WORDCOUNT Returns the number of words in a particular cell.
WORDGET Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION Returns the file extension of the active workbook.
WORKDAY6 Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC Returns the serial number before or after a given number of days from a start date using a defined list of workdays.

Add-in Functions

ACRONYM	Returns the first letter of each word.
AGE	Returns the age of a person given a birthday.
AVERAGEVISIBLE	Returns the average value from visible, non blank cells in a range.
AVERAGEVISIBLEIFS	Returns the average value from visible, non blank cells that satisfies multiple conditions.
BUSDAYNEXT	Returns the next business day if the given date is not a business day.
BUSDAYPREVIOUS	Returns the previous business day if the given date is not a business day.
COMMENTGET	Returns the comment associated with a particular cell.
COMPARECELLS	Returns a description of whether two ranges are identical or not.
CONTAINS	Returns whether a string is contained inside another string.
CONVERTTIME	Returns the time converted to a decimal, given hours, minutes or seconds.
COUNTBETWEEN	Returns the number of cells that have a value that is between a range.
COUNTFORMAT	Returns the number of cells that have a particular cell colour or font colour.
COUNTHIDDENSHEETS	Returns the number of hidden worksheets in the active workbook.
COUNTSUBSTRING	Returns the number of occurrences of a substring in a particular cell.
COUNTVISIBLE	Returns the number of visible, non blank cells in a range.
COUNTVISIBLEIFS	Returns the number of visible, non blank cells that satisfy multiple conditions.
DATEDIFFERENCE	(Replaces DATEDIF) Returns the number of days, months or years between two dates.
DATESERIAL	Returns the date serial number given a date in text format.
DAYSINAMONTH	Returns the number of days in a particular month and year.
DAYSINAYEAR	Returns the number of days in a particular year.
DAYSTO	Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS	Returns the number of days to the next Christmas.
DUPLICATECELLS	Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES	Returns the list of items that appear more than once.
EMAILVALID	Returns whether a string is a valid email address.
EXTRACTFILENAME	Returns only the file name from a full file path.
EXTRACTFOLDERPATH	Returns only the folder path from a full file path.
EXTRACTNUMBERS	Returns only the numbers from a text string.
FILEEXISTS	Returns whether a particular file exists.
FORMATGET	Returns a specific formatting attribute from a particular cell.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
ISBOLD	Returns whether a particular cell has been formatted in bold.
LASTINCOLUMN	Returns the last cell that contains data in a particular column.
LASTINROW	Returns the last cell that contains data in a particular row.
MAXVISIBLE	Returns the largest value from visible, non blank cells in a range.
MAXVISIBLEIFS	Returns the largest value from visible, non blank cells that satisfies multiple conditions.
MERGECELLS	Returns the contents from entire ranges and combines them to return a single string.
MINVISIBLE	Returns the smallest value from visible, non blank cells in a range.
MINVISIBLEIFS	Returns the smallest value from visible, non blank cells that satisfies multiple conditions.
NUMBERFORMATGET	Returns the number format that has been applied to a particular cell.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVENUMBERS	Returns any numbers from a text string.
REVERSE	Returns the contents of a particular cell with all the characters reversed.
SAMPLEDATA	Returns sample data into your worksheet.
SCRAMBLE	Returns the contents of a particular cell with all the characters in a random order.
SPELLNUMBER	Returns the text after converting a number into words.
SPELLNUMBERREVERSE	Returns the value after converting words into a number.
SUMFORMAT	Returns the sum of values that have a particular cell colour or font colour.
SUMVISIBLE	Returns the sum of visible, non blank cells in a range.
SUMVISIBLEIFS	Returns the sum of visible, non blank cells that satisfies multiple conditions.
TIMENOW	Returns the current time as a string (in the format "hh:mm:ss").
USERNAME	Returns the application's user name or the domain username.
WORKBOOKFILENAME	Returns the file name of the active workbook.
WORKBOOKPATH	Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME	Returns the folder path and file name of the active workbook.
WORKBOOKPROPERTIES	Returns a particular workbook property of the active workbook.
WORKSHEETNAME	Returns the name of a worksheet in the active workbook given an index position.

ACRONYM Returns the first letter of each word.
AGE Returns the age of a person given a birthday.
AVERAGEVISIBLE Returns the average value from visible, non blank cells in a range.
AVERAGEVISIBLEIFS Returns the average value from visible, non blank cells that satisfies multiple conditions.
BUSDAYNEXT Returns the next business day if the given date is not a business day.
BUSDAYPREVIOUS Returns the previous business day if the given date is not a business day.
COMMENTGET Returns the comment associated with a particular cell.
COMPARECELLS Returns a description of whether two ranges are identical or not.
CONTAINS Returns whether a string is contained inside another string.
CONVERTTIME Returns the time converted to a decimal, given hours, minutes or seconds.
COUNTBETWEEN Returns the number of cells that have a value that is between a range.
COUNTFORMAT Returns the number of cells that have a particular cell colour or font colour.
COUNTHIDDENSHEETS Returns the number of hidden worksheets in the active workbook.
COUNTSUBSTRING Returns the number of occurrences of a substring in a particular cell.
COUNTVISIBLE Returns the number of visible, non blank cells in a range.
COUNTVISIBLEIFS Returns the number of visible, non blank cells that satisfy multiple conditions.
DATEDIFFERENCE (Replaces DATEDIF) Returns the number of days, months or years between two dates.
DATESERIAL Returns the date serial number given a date in text format.
DAYSINAMONTH Returns the number of days in a particular month and year.
DAYSINAYEAR Returns the number of days in a particular year.
DAYSTO Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS Returns the number of days to the next Christmas.
DUPLICATECELLS Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES Returns the list of items that appear more than once.
EMAILVALID Returns whether a string is a valid email address.
EXTRACTFILENAME Returns only the file name from a full file path.
EXTRACTFOLDERPATH Returns only the folder path from a full file path.
EXTRACTNUMBERS Returns only the numbers from a text string.
FILEEXISTS Returns whether a particular file exists.
FORMATGET Returns a specific formatting attribute from a particular cell.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
ISBOLD Returns whether a particular cell has been formatted in bold.
LASTINCOLUMN Returns the last cell that contains data in a particular column.
LASTINROW Returns the last cell that contains data in a particular row.
MAXVISIBLE Returns the largest value from visible, non blank cells in a range.
MAXVISIBLEIFS Returns the largest value from visible, non blank cells that satisfies multiple conditions.
MERGECELLS Returns the contents from entire ranges and combines them to return a single string.
MINVISIBLE Returns the smallest value from visible, non blank cells in a range.
MINVISIBLEIFS Returns the smallest value from visible, non blank cells that satisfies multiple conditions.
NUMBERFORMATGET Returns the number format that has been applied to a particular cell.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVENUMBERS Returns any numbers from a text string.
REVERSE Returns the contents of a particular cell with all the characters reversed.
SAMPLEDATA Returns sample data into your worksheet.
SCRAMBLE Returns the contents of a particular cell with all the characters in a random order.
SPELLNUMBER Returns the text after converting a number into words.
SPELLNUMBERREVERSE Returns the value after converting words into a number.
SUMFORMAT Returns the sum of values that have a particular cell colour or font colour.
SUMVISIBLE Returns the sum of visible, non blank cells in a range.
SUMVISIBLEIFS Returns the sum of visible, non blank cells that satisfies multiple conditions.
TIMENOW Returns the current time as a string (in the format "hh:mm:ss").
USERNAME Returns the application's user name or the domain username.
WORKBOOKFILENAME Returns the file name of the active workbook.
WORKBOOKPATH Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME Returns the folder path and file name of the active workbook.
WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook.
WORKSHEETNAME Returns the name of a worksheet in the active workbook given an index position.