Restituisce il numero di giorni tra due date.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
DAYS(end_date, start_date)The DAYS function calculates the difference between two date values by subtracting the start_date from the end_date. It is useful for determining the duration of a project or the time elapsed between two specific calendar events.
=DAYS("2023-12-31", "2023-01-01")Risultato: 364
Calculates the number of days between January 1st and December 31st, 2023.
Yes, if the start_date is later than the end_date, the function will return a negative number.