DATE
DATE(year, month, day)
Converts a provided year, month, and day into a date. Learn more
Produttivita
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
33 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
DAY
DAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
Produttivita
Apri schedaMONTH
MONTH(date)
Returns the month of the year a specific date falls in, in numeric format. Learn more
Produttivita
Apri schedaNOW
NOW()
Returns the current date and time as a date value. Learn more
Produttivita
Apri schedaTODAY
TODAY()
Returns the current date as a date value. Learn more
Produttivita
Apri schedaYEAR
YEAR(date)
Returns the year specified by a given date. Learn more
Produttivita
Apri schedaFILTER
FILTER(range, condition1, [condition2])
Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. Learn more
Analisi dati Marketing Automazione
Apri schedaSORT
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
Sorts the rows of a given array or range by the values in one or more columns. Learn more
Analisi dati
Apri schedaAND
AND(logical_expression1, [logical_expression2, ...])
Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more
Produttivita
Apri schedaIF
IF(logical_expression, value_if_true, value_if_false)
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Learn more
Produttivita
Apri schedaIFERROR
IFERROR(value, [value_if_error])
Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent. Learn more
Produttivita
Apri schedaNOT
NOT(logical_expression)
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`. Learn more
Produttivita
Apri schedaOR
OR(logical_expression1, [logical_expression2, ...])
Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Learn more
Produttivita
Apri schedaCOUNTBLANK
COUNTBLANK(range)
Returns the number of empty cells in a given range. Learn more
Analisi dati
Apri schedaROUND
ROUND(value, [places])
Rounds a number to a certain number of decimal places according to standard rules. Learn more
Analisi dati
Apri schedaROUNDDOWN
ROUNDDOWN(value, [places])
Rounds a number to a certain number of decimal places, always rounding down to the next valid increment. Learn more
Analisi dati
Apri schedaROUNDUP
ROUNDUP(value, [places])
Rounds a number to a certain number of decimal places, always rounding up to the next valid increment. Learn more
Analisi dati
Apri schedaSUM
SUM(value1, [value2, ...])
Returns the sum of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaUNIQUE
UNIQUE(range, by_column, exactly_once)
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range. Learn more
Marketing Analisi dati
Apri schedaAVERAGE
AVERAGE(value1, [value2, ...])
Returns the numerical average value in a dataset, ignoring text. Learn more
Analisi dati
Apri schedaCOUNT
COUNT(value1, [value2, ...])
Returns a count of the number of numeric values in a dataset. Learn more
Analisi dati
Apri schedaCOUNTA
COUNTA(value1, [value2, ...])
Returns a count of the number of values in a dataset. Learn more
Analisi dati
Apri schedaMAX
MAX(value1, [value2, ...])
Returns the maximum value in a numeric dataset. Learn more
Analisi dati
Apri schedaMIN
MIN(value1, [value2, ...])
Returns the minimum value in a numeric dataset. Learn more
Analisi dati
Apri schedaCONCATENATE
CONCATENATE(string1, [string2, ...])
Appends strings to one another. Learn more
Marketing
Apri schedaJOIN
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. Learn more
Marketing
Apri schedaLEFT
LEFT(string, [number_of_characters])
Returns a substring from the beginning of a specified string. Learn more
Marketing
Apri schedaLEN
LEN(text)
Returns the length of a string. Learn more
Marketing
Apri schedaLOWER
LOWER(text)
Converts a specified string to lowercase. Learn more
Marketing
Apri schedaMID
MID(string, starting_at, extract_length)
Returns a segment of a string. Learn more
Marketing
Apri schedaRIGHT
RIGHT(string, [number_of_characters])
Returns a substring from the end of a specified string. Learn more
Marketing
Apri schedaTRIM
TRIM(text)
Removes leading and trailing spaces in a specified string. Learn more
Marketing
Apri schedaUPPER
UPPER(text)
Converts a specified string to uppercase. Learn more
Marketing
Apri scheda