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 Reply

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »
Scroll to Top