Returnerar antalet dagar mellan två datum.
Syntax
DAYS(end_date, start_date)Argument
end_dateobligatoriskt
The date that marks the end of the period.
start_dateobligatoriskt
The date that marks the beginning of the period.
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")→364Calculates the number of days between January 1st and December 31st, 2023.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =DAYS(end_date, start_date) using cell references or date strings.
Yes, if the start_date is later than the end_date, the function will return a negative number.