📄️ LEN
Returns the number of characters in a text string.
📄️ TRIM
Removes all spaces from text except for single spaces between words.
📄️ CEILING
Rounds a number up to the nearest multiple of specified significance.
📄️ CONCAT
Combines two or more text strings into one string.
📄️ CONTINENTS
Returns a list of all continents
📄️ COUNT
Counts the number of elements in an array.
📄️ COUNTIF
Counts the number of cells that meet a specified condition.
📄️ COUNTIFS
Counts the number of cells within a range that meet multiple criteria.
📄️ COUNTNIF
Counts the number of cells that do NOT meet a specified condition.
📄️ COUNTRIES
Returns a list of all countries
📄️ DATE
Returns the serial number of a particular date.
📄️ DATEADD
Adds a specified number of days, months, years, hours, minutes, or seconds to a given date
📄️ DATEDIF
Calculates the difference between two dates in various units.
📄️ DATESUBTRACT
Subtracts a specified number of days, months, years, hours, minutes, or seconds from a given date
📄️ DATEVALUE
Converts a date in text format to a date value that AnyDB recognizes.
📄️ DAY
Returns the day of the month (1-31) from a date value.
📄️ DAYS
Returns the number of days between two dates.
📄️ DYNREF
Returns the value of a cell pointed to by a reference item
📄️ FILTER
Filters a range of data based on specified criteria.
📄️ FILTERYEAR
Checks if a date is within a specific year.
📄️ FLOOR
Rounds a number down to the nearest multiple of specified significance.
📄️ GROUPBYSUM
Merges objects in an array that share a specified property, summing numerical values.
📄️ HOUR
Returns the hour (0-23) from a time value.
📄️ IF
Returns one value if a condition is true and another value if it's false.
📄️ IFERROR
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
📄️ ISMONTH
Checks if a date is within a specific month.
📄️ ISODATE
Returns the ISO date format (YYYY-MM-DD) for a given date.
📄️ ISYEAR
Checks if a date is within a specific year.
📄️ LANGUAGES
Returns a list of all languages
📄️ LEFT
Returns the specified number of characters from the start of a text string.
📄️ LOWER
Converts text to lowercase.
📄️ MAX
Returns the largest value in a set of values.
📄️ MAXBY
Returns the object with the maximum value of a specified property.
📄️ MEAN
Returns the arithmetic mean (average) of the numbers.
📄️ MID
Returns a specific number of characters from a text string, starting at the position you specify.
📄️ MIN
Description
📄️ MINUTE
Returns the minute (0-59) from a time value.
📄️ MONTH
Returns the month (1-12) from a date value.
📄️ PMT
Calculates the payment for a loan based on constant payments and a constant interest rate.
📄️ POWER
Description
📄️ PROPER
Capitalizes the first letter in each word of a text string.
📄️ READABLEDATE
Returns the Readable Date format (Mon dd, year) (December 1, 1999) for a given date.
📄️ READABLEDATETIME
Returns the Readable Date format (Mon dd, year at HR00 PM CST) for a given date.
📄️ READABLEPERCENT
Returns the Readable % format for a given number. The number is multiplied by 100 and a % sign is appended to the end of the number. For example, 0.25 becomes 25%.
📄️ REPLACE
Replaces characters within a text string with different characters.
📄️ RIGHT
Returns the specified number of characters from the end of a text string.
📄️ ROUND
Description
📄️ SECOND
Returns the second (0-59) from a time value.
📄️ SQRT
Returns the square root of a number.
📄️ STATES
Returns a list of all states/provinces for a given country
📄️ SUBSTITUTE
Replaces specific text in a text string with new text.
📄️ SUM
Adds all the numbers in a range of cells.
📄️ SUMBY
Sums the values of a specified property in an array of objects.
📄️ SUMIF
Adds the number of cells that meet a specified condition.
📄️ SUMIFS
Adds the cells in a range that meet multiple criteria.
📄️ TODAY
Returns the current date.
📄️ UPPER
Converts text to uppercase.
📄️ VLOOKUP
VLOOKUP is a function that searches for a value in the first column of a table and returns a value in the same row from a specified column. It is commonly used to look up data in large datasets.
📄️ WEEKDAY
Returns the day of the week for a given date.
📄️ WEEKNUM
Returns the week number in the year for a given date.
📄️ WORKDAY
Calculates a future or past date by adding or subtracting a specified number of workdays (Monday–Friday), optionally excluding holidays.
📄️ YEAR
Returns the year from a date value.
📄️ YEARFRAC
Returns the fraction of the year represented by the number of whole days between two dates