The 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("7/24/1969", "7/16/1969")
DAYS(“2/28/2016”, “2/28/2017”)
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.
