DATE
DATE(year, month, day)
Converts a provided year, month, and day into a 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.
26 formule trovate
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 scheda