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. | |
| AVERAGETOP | *Returns the average value from the cells with the top "x" values or percentage. | |
| AVERAGEVISIBLE | Returns the average value from visible, non blank cells in a range. | |
| AVERAGEVISIBLEA | *Returns the average value from visible, non blank cells in a range (including logical values and text). | |
| AVERAGEVISIBLEIFS | Returns the average value from visible, non blank cells that satisfies 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. | |
| 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. | |
| COUNTTEXTCELLS | *Returns the number of cells that contain text. | |
| COUNTVISIBLE | Returns the number of visible, non blank cells in a range. | |
| COUNTVISIBLEA | *Returns the number of visible, non blank cells in a range (including logical values and text). | |
| 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. | |
| MAXBETWEEN | *Returns the largest value that is between a range. | |
| MAXVISIBLE | Returns the largest value from visible, non blank cells in a range. | |
| MAXVISIBLEA | *Returns the largest value from visible, non blank cells in a range (including logical values and text). | |
| MAXVISIBLEIFS | Returns the largest value from visible, non blank cells that satisfies multiple conditions. | |
| 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. | |
| MERGECELLS | ||
| MINBETWEEN | *Returns the smallest value that is between a range. | |
| MINVISIBLE | Returns the smallest value from visible, non blank cells in a range. | |
| MINVISIBLEA | *Returns the smallest value from visible, non blank cells in a range (including logical values and text). | |
| MINVISIBLEIFS | Returns the smallest value from visible, non blank cells that satisfies 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. | |
| SAMPLEDATA | ||
| 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 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. | |
| 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. |
| AVERAGETOP *Returns the average value from the cells with the top "x" values or percentage. |
| AVERAGEVISIBLE Returns the average value from visible, non blank cells in a range. |
| AVERAGEVISIBLEA *Returns the average value from visible, non blank cells in a range (including logical values and text). |
| AVERAGEVISIBLEIFS Returns the average value from visible, non blank cells that satisfies 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. |
| 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. |
| COUNTTEXTCELLS *Returns the number of cells that contain text. |
| COUNTVISIBLE Returns the number of visible, non blank cells in a range. |
| COUNTVISIBLEA *Returns the number of visible, non blank cells in a range (including logical values and text). |
| 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. |
| MAXBETWEEN *Returns the largest value that is between a range. |
| MAXVISIBLE Returns the largest value from visible, non blank cells in a range. |
| MAXVISIBLEA *Returns the largest value from visible, non blank cells in a range (including logical values and text). |
| MAXVISIBLEIFS Returns the largest value from visible, non blank cells that satisfies multiple conditions. |
| 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. |
| MERGECELLS |
| MINBETWEEN *Returns the smallest value that is between a range. |
| MINVISIBLE Returns the smallest value from visible, non blank cells in a range. |
| MINVISIBLEA *Returns the smallest value from visible, non blank cells in a range (including logical values and text). |
| MINVISIBLEIFS Returns the smallest value from visible, non blank cells that satisfies 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. |
| SAMPLEDATA |
| 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 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. |
| 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. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext