The DAYS function returns the number of days between two dates.
Parts of a DAYS function
||The end of the date range.|
||The start of the date range.|
The DAYS function factors in leap days.
The below example shows the difference between two days in the same month.
The below example shows the difference between two dates factoring in a leap day:
- 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.