DATEDIF
DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. 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.
369 formule trovate · pagina 1 di 8
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
DATEVALUE
DATEVALUE(date_string)
Converts a provided date string in a known format to a date value. 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 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 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 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 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 schedaSORTN
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Returns the first n items in a data set after performing a sort. Learn more
Analisi dati
Apri schedaACCRINT
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Calculates the accrued interest of a security that has periodic payments. Learn more
Finance
Apri schedaACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
Finance
Apri schedaAMORLINC
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more.
Finance
Apri schedaCOUPDAYBS
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more
Finance
Apri schedaCOUPDAYS
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more
Finance
Apri schedaCOUPDAYSNC
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more
Finance
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
Finance
Apri schedaCOUPNUM
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more
Finance
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
Finance
Apri schedaCUMIPMT
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaCUMPRINC
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaDB
DB(cost, salvage, life, period, [month])
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more
Finance
Apri schedaDDB
DDB(cost, salvage, life, period, [factor])
Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more
Finance
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Finance
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Finance
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
Finance
Apri schedaDURATION
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more
Finance
Apri schedaEFFECT
EFFECT(nominal_rate, periods_per_year)
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more
Finance
Apri schedaFV
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaFVSCHEDULE
FVSCHEDULE(principal, rate_schedule)
Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more
Finance
Apri schedaINTRATE
INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])
Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more
Finance
Apri schedaIPMT
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaIRR
IRR(cashflow_amounts, [rate_guess])
Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more
Finance
Apri schedaISPMT
ISPMT(rate, period, number_of_periods, present_value)
The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.
Finance
Apri schedaMDURATION
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])
Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaMIRR
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more
Finance
Apri schedaNOMINAL
NOMINAL(effective_rate, periods_per_year)
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more
Finance
Apri scheda