DATE
DATE(year, month, day)
Converts a provided year, month, and day into a date. Learn more
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.
DATEDIF
DATEDIF(start_date, end_date, unit)
Calculates the number of days, months, or years between two dates. Learn more
Apri schedaDATEVALUE
DATEVALUE(date_string)
Converts a provided date string in a known format to a date value. Learn more
Apri schedaDAY
DAY(date)
Returns the day of the month that a specific date falls on, in numeric format. Learn more
Apri schedaDAYS
DAYS(end_date, start_date)
Returns the number of days between two dates. Learn more.
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
Apri schedaEDATE
EDATE(start_date, months)
Returns a date a specified number of months before or after another date. Learn more
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
Apri schedaEPOCHTODATE
EPOCHTODATE(timestamp, [unit])
Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. Learn more
Apri schedaHOUR
HOUR(time)
Returns the hour component of a specific time, in numeric format. Learn more
Apri schedaISOWEEKNUM
ISOWEEKNUM(date)
Returns the number of the ISO week of the year where the provided date falls. Learn more
Apri schedaMINUTE
MINUTE(time)
Returns the minute component of a specific time, in numeric format. Learn more
Apri schedaMONTH
MONTH(date)
Returns the month of the year a specific date falls in, in numeric format. Learn more
Apri schedaNETWORKDAYS
NETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days. Learn more
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
Apri schedaNOW
NOW()
Returns the current date and time as a date value. Learn more
Apri schedaSECOND
SECOND(time)
Returns the second component of a specific time, in numeric format. Learn more
Apri schedaTIME
TIME(hour, minute, second)
Converts a provided hour, minute, and second into a time. Learn more
Apri schedaTIMEVALUE
TIMEVALUE(time_string)
Returns the fraction of a 24-hour day the time represents. Learn more
Apri schedaTODAY
TODAY()
Returns the current date as a date value. Learn more
Apri schedaWEEKDAY
WEEKDAY(date, [type])
Returns a number representing the day of the week of the date provided. Learn more
Apri schedaWEEKNUM
WEEKNUM(date, [type])
Returns a number representing the week of the year where the provided date falls. Learn more
Apri schedaWORKDAY
WORKDAY(start_date, num_days, [holidays])
Calculates the end date after a specified number of working days. Learn more
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
Apri schedaYEAR
YEAR(date)
Returns the year specified by a given date. Learn more
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
Apri scheda