User Defined Functions Complete List

ACRONYM	Returns the first letter of each word.
AGE	Returns the age of a person given a birthday.
ALLSHEETS	Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE	Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOP	Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE	Returns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFS	Returns the average value from the visible, non blank cells that satisfy multiple conditions.
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.
BUSDAYNEXT	Returns the next business day if the given date is not a business day.
BUSDAYNTH	Returns the nth business day in a particular month and year.
BUSDAYPREVIOUS	Returns the previous business day if the given date is not a business day.
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.
COMMENTGET	Returns the comment associated with a particular cell.
COMPARECELLS	Returns a description of whether two ranges are identical or not.
COMPUTERNAME	Returns the full computer name.
CONVERTTIME	Returns the time converted to a decimal, given hours, minutes or seconds.
CONTAINS	Returns whether a string is contained inside another string.
COUNTAVISIBLE	Returns the number of visible, non blank cells in a range (including logical values and text).
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.
COUNTTEXTCELLS	Returns the number of cells that contain text.
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.
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.
DATEDIFFERENCE	(Replaces DATEDIF) Returns the number of days, months or years 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.
DATESERIAL	Returns the date serial number given a date in text format.
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.
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.
EXCELDIR	Returns the various folder locations that Excel uses including installation and startup.
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.
EXTRACTTEXT	Returns only the text from a text string that contains other characters as well.
FILEEXISTS	Returns whether a particular file exists.
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.
FORMATGET	Returns a specific formatting attribute from a particular cell.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
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.
ISBOLD	Returns whether a particular cell has been formatted in bold.
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.
LASTINCOLUMN	Returns the last cell that contains data in a particular column.
LASTINROW	Returns the last cell that contains data in a particular row.
LASTWORD	Returns the last word from a text string.
MAXAVISIBLE	Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN	Returns the largest value that is between a range.
MAXVISIBLE	Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS	Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MEDIANIFS	Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE	Returns the middle value from the visible cells.
MEDIANVISIBLEIFS	Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MINAVISIBLE	Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN	Returns the smallest value that is between a range.
MINVISIBLE	Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS	Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
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.
NUMBERFORMATGET	Returns the number format that has been applied to a particular cell.
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.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVENUMBERS	Returns any numbers from a text string.
REMOVESPACES	Returns a text string with any spaces removed.
REMOVETEXT	Returns a text string with a substring removed.
REVERSE	Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT	Returns the row height of a particular cell.
SCRAMBLE	Returns the contents of a particular cell with all the characters in a random order.
SELECTONE	Returns a value at random from a range of cells.
SHEETOFFSET	Returns the contents of a cell on a different worksheet.
SPELLNUMBER	Returns the text after converting a number into words.
SPELLNUMBERREVERSE	Returns the value after converting words into a number.
SUMBETWEEN	Returns the sum of values that are between a range.
SUMDIGITS	Returns the sum of the digits in a particular cell.
SUMFORMAT	Returns the sum of values that have a particular cell colour or font colour.
SUMVISIBLE	Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS	Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
TIMENOW	Returns the current time as a string (in the format "hh:mm:ss").
TRANSLATE	Returns the text translated into another language.
USERNAME	Returns the application's user name or the domain username.
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.
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.
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.
WORKSHEETNAME	Returns the name of a worksheet in the active workbook given an index position.
XLOOKUPINTERPOLATE	Returns an interpolated value if an exact match is not found.

ACRONYM Returns the first letter of each word.
AGE Returns the age of a person given a birthday.
ALLSHEETS Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGETOP Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE Returns the average value from the visible, non blank cells.
AVERAGEVISIBLEIFS Returns the average value from the visible, non blank cells that satisfy multiple conditions.
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.
BUSDAYNEXT Returns the next business day if the given date is not a business day.
BUSDAYNTH Returns the nth business day in a particular month and year.
BUSDAYPREVIOUS Returns the previous business day if the given date is not a business day.
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.
COMMENTGET Returns the comment associated with a particular cell.
COMPARECELLS Returns a description of whether two ranges are identical or not.
COMPUTERNAME Returns the full computer name.
CONVERTTIME Returns the time converted to a decimal, given hours, minutes or seconds.
CONTAINS Returns whether a string is contained inside another string.
COUNTAVISIBLE Returns the number of visible, non blank cells in a range (including logical values and text).
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.
COUNTTEXTCELLS Returns the number of cells that contain text.
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.
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.
DATEDIFFERENCE (Replaces DATEDIF) Returns the number of days, months or years 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.
DATESERIAL Returns the date serial number given a date in text format.
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.
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.
EXCELDIR Returns the various folder locations that Excel uses including installation and startup.
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.
EXTRACTTEXT Returns only the text from a text string that contains other characters as well.
FILEEXISTS Returns whether a particular file exists.
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.
FORMATGET Returns a specific formatting attribute from a particular cell.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
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.
ISBOLD Returns whether a particular cell has been formatted in bold.
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.
LASTINCOLUMN Returns the last cell that contains data in a particular column.
LASTINROW Returns the last cell that contains data in a particular row.
LASTWORD Returns the last word from a text string.
MAXAVISIBLE Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN Returns the largest value that is between a range.
MAXVISIBLE Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MEDIANIFS Returns the middle value from the cells that satisfy multiple conditions.
MEDIANVISIBLE Returns the middle value from the visible cells.
MEDIANVISIBLEIFS Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MINAVISIBLE Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN Returns the smallest value that is between a range.
MINVISIBLE Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
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.
NUMBERFORMATGET Returns the number format that has been applied to a particular cell.
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.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVENUMBERS Returns any numbers from a text string.
REMOVESPACES Returns a text string with any spaces removed.
REMOVETEXT Returns a text string with a substring removed.
REVERSE Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT Returns the row height of a particular cell.
SCRAMBLE Returns the contents of a particular cell with all the characters in a random order.
SELECTONE Returns a value at random from a range of cells.
SHEETOFFSET Returns the contents of a cell on a different worksheet.
SPELLNUMBER Returns the text after converting a number into words.
SPELLNUMBERREVERSE Returns the value after converting words into a number.
SUMBETWEEN Returns the sum of values that are between a range.
SUMDIGITS Returns the sum of the digits in a particular cell.
SUMFORMAT Returns the sum of values that have a particular cell colour or font colour.
SUMVISIBLE Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
TIMENOW Returns the current time as a string (in the format "hh:mm:ss").
TRANSLATE Returns the text translated into another language.
USERNAME Returns the application's user name or the domain username.
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.
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.
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.
WORKSHEETNAME Returns the name of a worksheet in the active workbook given an index position.
XLOOKUPINTERPOLATE Returns an interpolated value if an exact match is not found.