EDATE
EDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
Produttivita
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
515 formule trovate · pagina 2 di 11
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
EOMONTH
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 schedaBIN2DEC
BIN2DEC(signed_binary_number)
Converts a signed binary number to decimal format. Learn more
Automazione
Apri schedaBIN2HEX
BIN2HEX(signed_binary_number, [significant_digits])
Converts a signed binary number to signed hexadecimal format. Learn more
Automazione
Apri schedaBIN2OCT
BIN2OCT(signed_binary_number, [significant_digits])
Converts a signed binary number to signed octal format. Learn more
Automazione
Apri schedaBITAND
BITAND(value1, value2)
Bitwise boolean AND of two numbers. Learn more.
Automazione
Apri schedaBITLSHIFT
BITLSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the left. Learn more.
Automazione
Apri schedaBITOR
BITOR(value1, value2)
Bitwise boolean OR of 2 numbers. Learn more.
Automazione
Apri schedaBITRSHIFT
BITRSHIFT(value, shift_amount)
Shifts the bits of the input a certain number of places to the right. Learn more.
Automazione
Apri schedaBITXOR
BITXOR(value1, value2)
Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
Automazione
Apri schedaCOMPLEX
COMPLEX(real_part, imaginary_part, [suffix])
Creates a complex number given real and imaginary coefficients. Learn more
Automazione
Apri schedaDEC2BIN
DEC2BIN(decimal_number, [significant_digits])
Converts a decimal number to signed binary format. Learn more
Automazione
Apri schedaDEC2HEX
DEC2HEX(decimal_number, [significant_digits])
Converts a decimal number to signed hexadecimal format. Learn more
Automazione
Apri schedaDEC2OCT
DEC2OCT(decimal_number, [significant_digits])
Converts a decimal number to signed octal format. Learn more
Automazione
Apri schedaDELTA
DELTA(number1, [number2])
Compare two numeric values, returning 1 if they're equal. Learn more
Automazione
Apri schedaERF
ERF(lower_bound, [upper_bound])
The ERF function returns the integral of the Gauss error function over an interval of values. Learn more.
Automazione
Apri schedaERF.PRECISE
ERF.PRECISE(lower_bound, [upper_bound])
See ERF
Automazione
Apri schedaGESTEP
GESTEP(value, [step])
Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used. Learn more.
Automazione
Apri schedaHEX2BIN
HEX2BIN(signed_hexadecimal_number, [significant_digits])
Converts a signed hexadecimal number to signed binary format. Learn more
Automazione
Apri schedaHEX2DEC
HEX2DEC(signed_hexadecimal_number)
Converts a signed hexadecimal number to decimal format. Learn more
Automazione
Apri schedaHEX2OCT
HEX2OCT(signed_hexadecimal_number, significant_digits)
Converts a signed hexadecimal number to signed octal format. Learn more
Automazione
Apri schedaIMABS
IMABS(number)
Returns absolute value of a complex number. Learn more
Automazione
Apri schedaIMAGINARY
IMAGINARY(complex_number)
Returns the imaginary coefficient of a complex number. Learn more
Automazione
Apri schedaIMARGUMENT
IMARGUMENT(number)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians. Learn more.
Automazione
Apri schedaIMCONJUGATE
IMCONJUGATE(number)
Returns the complex conjugate of a number. Learn more
Automazione
Apri schedaIMCOS
IMCOS(number)
The IMCOS function returns the cosine of the given complex number. Learn more.
Automazione
Apri schedaIMCOSH
IMCOSH(number)
Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.
Automazione
Apri schedaIMCOT
IMCOT(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.
Automazione
Apri schedaIMCOTH
IMCOTH(number)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.
Automazione
Apri schedaIMCSC
IMCSC(number)
Returns the cosecant of the given complex number. Learn more.
Automazione
Apri scheda