DAYS functionThe DAYS function returns the number of days between two dates.
Parts of a DAYS function
DAYS(end_date,start_date)
Part
Description
Notes
end_date
The end of the date range.
start_date
The start of the date range.
Sample formulas
DAYS(“2/28/2016”, “2/28/2017”)DAYS(“7/24/1969”, “7/16/1969”)
Notes
The DAYS function factors in leap days.
Examples
The below example shows the difference between two days in the same month.
A
B
1
Formula
Result
2
=DAYS(“7/24/1969”, “7/16/1969”)
8
The below example shows the difference between two dates factoring in a leap day:
A
B
1
Formula
Result
2
=DAYS(“2/28/2016”, “2/28/2017”)
366
Related functions
DAY: Returns the day of the month that a specific date falls on, in numeric format.
DAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.
NETWORKDAYS: Returns the number of net working days between two provided days.