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.