How DAYS or DAYS360 works in EXCEL

Description :

Returns the number of days between two dates.

Syntax :
DAYS360(end_date, start_date) or DAYS(end_date, start_date)
 
The DAYS function syntax has the following arguments.

Argument	Description
End_date	Required. Start_date and End_date are the two dates between which you want to know the number of days.
Start_date	Required. Start_date and End_date are the two dates between which you want to know the number of days.

Note: Excel stores dates as sequential serial numbers so that they can be used in calculations.

Remarks:

ü  If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates.

ü  If either one of the date arguments is text, that argument is treated as DATEVALUE(date_text) and returns an integer date instead of a time component.

ü  If date arguments are numeric values that fall outside the range of valid dates, DAYS returns the #NUM! error value.

ü  If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value.

 

Example: