DAYS Function in Excel

The DAYS function in Excel calculates the number of days between two dates. This is a relatively simple function that only has two required arguments.


 =DAYS (end_date, start_date) 


  • end_date – (required) – Must be valid ending date
  • start_date – (required) Must be valid starting date

DAYS Function Usage Example:

Returns the number of days between two dates.

DAYS Function

Usage Errors

Valid dates must be used. For example, February 31, 1999 is not a valid date.

Other Usage Examples:

Let’s deal with negative dates. In the above example, we received a result of -65 days. In order to fix this in Excel, we will use the ABS Function. This function is used to turn the number or days returned into a positive number.

DAYS Function

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend