Renvoie le nombre de jours entre deux dates.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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")Résultat : 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.