Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and...

IMPORTXML(url, xpath_query)

Calculates the number of days, months, or years between two dates.

DATEDIF(start_date, end_date, unit)

Returns a count of the number of numeric values in a dataset.

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

Returns the minimum value in a numeric dataset.

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

Returns a segment of a string.

MID(string, starting_at, extract_length)

Returns true if any of the provided arguments are logically true, and false if all of the provide...

OR(logical_expression1, [logical_expression2, ...])

Flattens all the values from one or more ranges into a single column.

FLATTEN(range1,[range2,...])

Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.

NOT(logical_expression)

Returns the year specified by a given date.

YEAR(date)

Rounds a number to a certain number of decimal places, always rounding up to the next valid incre...

ROUNDUP(value, [places])

Returns the number of empty cells in a given range.

COUNTBLANK(range)

Counts the number of unique values in a list of specified values and ranges.

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

Returns a date representing the last day of a month which falls a specified number of months befo...

EOMONTH(start_date, months)

Translates text from one language into another

GOOGLETRANSLATE(text, [source_language], [target_language])

Converts a provided year, month, and day into a date.

DATE(year, month, day)

Runs a Google Visualization API Query Language query across data.

QUERY(data, query, [headers])

Evaluates multiple conditions and returns a value that corresponds to the first true condition..

IFS(condition1, value1, [condition2, value2], …)

Checks whether a value is a valid URL.

ISURL(value)

Returns an array of sequential numbers, such as 1, 2, 3, 4..

SEQUENCE(rows, columns, start, step)

Convert a number into a character according to the current Unicode table.

CHAR(table_number)

Returns the logical value `TRUE`.

TRUE()

Identifies the language used in text within the specified range.

DETECTLANGUAGE(text_or_range)

Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` ope...

EQ(value1, value2)

Checks whether a value is text.

ISTEXT(value)

Encodes a string of text for the purpose of using in a URL query..

ENCODEURL(text)

Returns a date a specified number of months before or after another date.

EDATE(start_date, months)

Returns a number representing the day of the week of the date provided.

WEEKDAY(date, [type])

Calculates the end date after a specified number of working days.

WORKDAY(start_date, num_days, [holidays])

Returns the hour component of a specific time, in numeric format.

HOUR(time)

Horizontal lookup. Searches across the first row of a range for a key and returns the value of a ...

HLOOKUP(search_key, range, index, [is_sorted])

Returns a substring from the beginning of a specified string.

LEFT(string, [number_of_characters])

Returns the day of the month that a specific date falls on, in numeric format.

DAY(date)

Calculates the future value of an annuity investment based on constant-amount periodic payments a...

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

Returns the count of a range depending on multiple criteria.

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Converts a string in any of the date, time or number formats that Google Sheets understands into ...

VALUE(text)

Returns the median value in a numeric dataset.

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

Returns the rank of a specified value in a dataset.

RANK(value, data, [is_ascending])

Checks whether a formula is in the referenced cell.

ISFORMULA(cell)

Checks whether a value is a valid email address.

ISEMAIL(value)

Removes leading and trailing spaces in a specified string.

TRIM(text)

Converts a decimal number to signed hexadecimal format.

DEC2HEX(decimal_number, [significant_digits])

Rounds a number to a certain number of decimal places, always rounding down to the next valid inc...

ROUNDDOWN(value, [places])

Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `&l...

NE(value1, value2)

Extracts matching substrings according to a regular expression.

REGEXEXTRACT(text, regular_expression)

Replaces part of a text string with a different text string using regular expressions.

REGEXREPLACE(text, regular_expression, replacement)

Returns the fraction of a 24-hour day the time represents.

TIMEVALUE(time_string)

Counts values, including text, selected from a database table-like array or range using a SQL-lik...

DCOUNTA(database, field, criteria)

Returns a substring from the end of a specified string.

RIGHT(string, [number_of_characters])