Below is a list of all available formula functions in Layer organized by type:

Date

DATE(year, month, day)

• year - The year component of the date.

• month - The month component of the date.

• day - The day component of the date.

DATEDIF(start_date, end_date, unit)

• start_date - The beginning date.

• end_date - The ending date.

• unit - The type of difference to return: "Y", "M", or "D".

DATEVALUE(date_string)

• date_string - The string representing the date.

DAY(date)

• date - The date from which to extract the day. Must be a reference to a cell containing a date, a function returning a date type, or a number.

DAYS(end_date, start_date)

• end_date - The later date.

• start_date - The earlier date.

DAYS360(start_date, end_date, [method])

• Calculates the number of days between two dates based on a 360-day year.

• Optional method argument: TRUE uses the European method.

EDATE(start_date, months)

• Returns a date that is the specified number of months before or after the start date.

EOMONTH(start_date, months)

• Returns the last day of the month before or after a specified number of months.

HOUR(time)

• Returns the hour (0–23) from a time value.

ISOWEEKNUM(date)

• Returns the ISO week number of the year for a given date.

MINUTE(time)

• Returns the minute (0–59) from a time value.

MONTH(date)

• Returns the month number (1–12) from a date.

NOW()

• Returns the current date and time.

SECOND(time)

• Returns the second (0–59) from a time value.

TIME(hour, minute, second)

• Returns a time value given hour, minute, and second.

TIMEVALUE(time_string)

• Converts a time in text format to a serial number.

TODAY()

• Returns the current date.

WEEKDAY(date, [type])

• Returns the day of the week for a date, numbered depending on type.

WEEKNUM(date, [type])

• Returns the week number in the year.

WORKDAY(start_date, days, [holidays])

• Returns the date after a number of working days. Optional holidays may be excluded.

WORKDAY.INTL(start_date, days, [weekend], [holidays])

• Returns a date after a number of working days, using custom weekend parameters.

YEAR(date)

• Returns the year from a date.

YEARFRAC(start_date, end_date, [basis])

• Returns the year fraction between two dates.

Text

CONCATENATE('text', ' ', 'text')

• Click values on the left to include in the formula.

• Text to be included must be placed between ' '.

• Use commas to separate each item.

CONCAT(text1, [text2], ...)

• Joins values or strings together without separators.

TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

• Joins text using a specified delimiter.

• Set ignore_empty to TRUE to skip blank values.

LEFT(text, [num_chars])

• Returns the leftmost characters from a text value.

RIGHT(text, [num_chars])

• Returns the rightmost characters from a text value.

MID(text, start_num, num_chars)

• Returns a substring from the middle of a text value.

LEN(text)

• Returns the number of characters in a text string.

LOWER(text)

• Converts text to lowercase.

UPPER(text)

• Converts text to uppercase.

PROPER(text)

• Capitalizes the first letter in each word.

TRIM(text)

• Removes extra spaces from text.

REPLACE(old_text, start_num, num_chars, new_text)

• Replaces part of a text string with new text.

SUBSTITUTE(text, old_text, new_text, [instance_num])

• Replaces specific text occurrences within a string.

FIND(find_text, within_text, [start_num])

• Finds one text value within another (case-sensitive).

SEARCH(find_text, within_text, [start_num])

• Finds one text value within another (not case-sensitive).

TEXT(value, format_text)

• Formats a number and converts it to text.

VALUE(text)

• Converts a text value that represents a number into a numeric value.

NUMBERVALUE(text, [decimal_sep], [group_sep])

• Converts text to number in a locale-independent manner.

EXACT(text1, text2)

• Checks if two text values are identical (case-sensitive).

CHAR(number)

• Returns the character specified by the number code.

CODE(text)

• Returns a numeric code for the first character in a text string.

UNICHAR(number)

• Returns the Unicode character referenced by the given numeric value.

UNICODE(text)

• Returns the Unicode code point of the first character.

Math

ROUND(value, 2)

• value - The number you want to round (numbers only, cannot use text fields).

• 2 - The number of decimal places you want to round to.

ROUNDUP(number, num_digits)

• Rounds a number up, away from zero.

ROUNDDOWN(number, num_digits)

• Rounds a number down, toward zero.

MROUND(number, multiple)

• Rounds to the nearest specified multiple.

CEILING(number, significance)

• Rounds a number up to the nearest multiple of significance.

FLOOR(number, significance)

• Rounds a number down to the nearest multiple of significance.

INT(number)

• Rounds a number down to the nearest integer.

TRUNC(number, [num_digits])

• Truncates a number to an integer or specified decimal places.

ABS(number)

• Returns the absolute value of a number.

SIGN(number)

• Returns 1, 0, or -1 depending on the sign of the number.

POWER(number, power)

• Returns a number raised to a specified power.

SQRT(number)

• Returns the positive square root of a number.

MOD(number, divisor)

• Returns the remainder from division.

SUM(number1, [number2], ...)

• Adds all the numbers in a range of cells.

SUMIF(range, criteria, [sum_range])

• Adds the cells specified by a given condition or criteria.

AVERAGE(number1, [number2], ...)

• Returns the average of the arguments.

MIN(number1, [number2], ...)

• Returns the smallest number in a set of values.

MAX(number1, [number2], ...)

• Returns the largest number in a set of values.

COUNT(value1, [value2], ...)

• Counts the number of values that contain numbers.

RAND()

• Returns a random number between 0 and 1.

RANDBETWEEN(bottom, top)

• Returns a random number between the numbers you specify.