The DAYS Function in Excel

This guide provides a practical overview of DAYS Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns the number of days between 2 dates, the support function is from Excel 2013 version onwards.

Syntax: DAYS (en d_date, start_date)

Inside:

- end_date: The start date to calculate the number of days, is a required parameter.

- start_date: End date to calculate the number of days, is a required parameter.

Attention:

- If both end_date and start_date are numeric -> the function uses EndDate – StartDate to calculate the number of days between two dates.

- If one of the arguments end_date and start_date is text, it takes the date value via the DATEVALUE (date_text) function.

- If 1 of the 2 arguments end_date and start_date is outside the valid range of the day -> the function returns the #NUM! Error value

- If 1 of the 2 arguments end_date and start_date cannot be parsed into a valid date -> the function returns the #VALUE! Error value

For example:

Calculate the number of days between the following dates according to the description table:

- In the cell to calculate enter the formula: = DAYS (F7, I7).

- Press Enter -> The total number of days between the 2 days above is:

- Similarly copying the formula for the remaining values results:

- In case of entering the wrong date value -> function returns the error value #VALUE!

Here the month / day / year format because the wrong month value is 15, the function returns the #VALUE! Error value .

Above are instructions and some specific examples when using the DAYS function in Excel.

Good luck!