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.
55 formule trovate · pagina 1 di 2
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
DATEDIF
DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. Learn more
Produttivita
Apri schedaDATEVALUE
DATEVALUE(date_string)
Converts a provided date string in a known format to a date value. Learn more
Produttivita
Apri schedaDAY
DAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
Produttivita
Apri schedaDAYS
DAYS(end_date, start_date)
Returns the number of days between two dates. Learn more.
Produttivita
Apri schedaDAYS360
DAYS360(start_date, end_date, [method])
Returns the difference between two days based on the 360 day year used in some financial interest calculations. Learn more
Produttivita
Apri schedaEDATE
EDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
Produttivita
Apri schedaEOMONTH
EOMONTH(start_date, months)
Returns a date representing the last day of a month which falls a specified number of months before or after another date. Learn more
Produttivita
Apri schedaEPOCHTODATE
EPOCHTODATE(timestamp, [unit])
Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. Learn more
Produttivita
Apri schedaHOUR
HOUR(time)
Returns the hour component of a specific time, in numeric format. Learn more
Produttivita
Apri schedaISOWEEKNUM
ISOWEEKNUM(date)
Returns the number of the ISO week of the year where the provided date falls. Learn more
Produttivita
Apri schedaMINUTE
MINUTE(time)
Returns the minute component of a specific time, 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 schedaNETWORKDAYS
NETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days. Learn more
Produttivita
Apri schedaNETWORKDAYS.INTL
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Returns the number of net working days between two provided days excluding specified weekend days and holidays. Learn more
Produttivita
Apri schedaNOW
NOW()
Returns the current date and time as a date value. Learn more
Produttivita
Apri schedaSECOND
SECOND(time)
Returns the second component of a specific time, in numeric format. Learn more
Produttivita
Apri schedaTIME
TIME(hour, minute, second)
Converts a provided hour, minute, and second into a time. Learn more
Produttivita
Apri schedaTIMEVALUE
TIMEVALUE(time_string)
Returns the fraction of a 24-hour day the time represents. Learn more
Produttivita
Apri schedaTODAY
TODAY()
Returns the current date as a date value. Learn more
Produttivita
Apri schedaWEEKDAY
WEEKDAY(date, [type])
Returns a number representing the day of the week of the date provided. Learn more
Produttivita
Apri schedaWEEKNUM
WEEKNUM(date, [type])
Returns a number representing the week of the year where the provided date falls. Learn more
Produttivita
Apri schedaWORKDAY
WORKDAY(start_date, num_days, [holidays])
Calculates the end date after a specified number of working days. Learn more
Produttivita
Apri schedaWORKDAY.INTL
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Calculates the date after a specified number of workdays excluding specified weekend days and holidays. Learn more
Produttivita
Apri schedaYEAR
YEAR(date)
Returns the year specified by a given date. Learn more
Produttivita
Apri schedaYEARFRAC
YEARFRAC(start_date, end_date, [day_count_convention])
Returns the number of years, including fractional years, between two dates using a specified day count convention. Learn more
Produttivita
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 schedaFALSE
FALSE()
Returns the logical value `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 schedaIFNA
IFNA(value, value_if_na)
Evaluates a value. If the value is an #N/A error, returns the specified value. Learn more.
Produttivita
Apri schedaIFS
IFS(condition1, value1, [condition2, value2], …)
Evaluates multiple conditions and returns a value that corresponds to the first true condition. Learn more.
Produttivita
Apri schedaLAMBDA
LAMBDA(name, formula_expression)
Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares. Learn more
Produttivita
Apri schedaLET
LET(name1, value_expression1, [name2, …], [value_expression2, …], formula_expression )
Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times. 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 schedaSWITCH
SWITCH(expression, case1, value1, [default or case2, value2], …)
Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met. Learn more
Produttivita
Apri schedaTRUE
TRUE()
Returns the logical value `TRUE`. Learn more
Produttivita
Apri schedaXOR
XOR(logical_expression1, [logical_expression2, ...])
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise. Learn more.
Produttivita
Apri schedaADD
ADD(value1, value2)
Returns the sum of two numbers. Equivalent to the `+` operator. Learn more
Produttivita
Apri schedaCONCAT
CONCAT(value1, value2)
Returns the concatenation of two values. Equivalent to the `&` operator. Learn more
Produttivita
Apri schedaDIVIDE
DIVIDE(dividend, divisor)
Returns one number divided by another. Equivalent to the `/` operator. Learn more
Produttivita
Apri schedaEQ
EQ(value1, value2)
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator. Learn more
Produttivita
Apri schedaGT
GT(value1, value2)
Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator. Learn more
Produttivita
Apri schedaGTE
GTE(value1, value2)
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator. Learn more
Produttivita
Apri schedaISBETWEEN
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more
Produttivita
Apri schedaLT
LT(value1, value2)
Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator. Learn more
Produttivita
Apri schedaLTE
LTE(value1, value2)
Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator. Learn more
Produttivita
Apri scheda