Excel DAYS Function

This tutorial demonstrates how to use the Excel DAYS Function in Excel to count the number of days between dates.

DAYS Main Function

DAYS Function Overview

The DAYS Function Returns the number of days between two dates.

To use the DAYS Excel Worksheet Function, select a cell and type:

Days Function

(Notice how the formula inputs appear)

Syntax and Arguments:

end_date – The end date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

start_date – The start date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

 

Calculate Number of Days Between Dates

The DAYS Function returns the number of days between two dates. The DAYS Function even works with dates stored as text. It returns a positive number if the end_date is after the start_date:

Days Positive

or a negative number of the end_date is before the start_date:

Days Negative

Absolute Date Difference

To calculate the absolute difference between two dates (no negative values) surround the DAYS Function with the ABS Function:

ABS DaysSubtract Dates

Instead of using the DAYS Function, you can usually simply subtract two dates to calculate the number of days between them:

Days SubtractHowever, this won’t work with dates stored as text.

Also, this method might return an unexpected result if a time value is stored with the dates. Read our article on calculating the difference between dates to learn more.

Days From Today

To calculate the number of days between a date and Today use the TODAY Function as one of the dates:

Days From TodayDAYS360 Function

Instead if you need to calculate the number of days between dates using a 360 day year (where each month has 30 days), use the DAYS360 Function:

DAYS360 days Four months

DAYS360 Four monthsNETWORKINGDAYS Function

The NETWORKINGDAYS Function will calculate the number of business days between dates:

DAYS NETWORKING DAYS

DAYS in Google Sheets

The DAYS Function works exactly the same in Google Sheets as in Excel:

DAYS Google Sheet