### DAYS(end_date, start_date)

Returns the number of days between two dates.

 end_date The date that represents the finishing date. start_date The date that represents the starting date.

#### Remarks

 * Added in Excel 2013.* If "end_date" contains any time information, it is ignored.* If "end_date" is not a valid date, then #VALUE! is returned.* If "end_date" is not a valid serial number, then #NUM! is returned.* If "start_date" contains any time information, it is ignored.* If "start_date" is not a valid date, then #VALUE! is returned* If "start_date" is not a valid serial number, then #NUM! is returned.* This function can handle dates in text format.* You can use the DATE function to return the date serial number given a year, month, day.* You can use the DAYS360 function to return the number of days between two dates, based on 30 day months.* You can use the NETWORKDAYS.INTL function to return the total number of working days between two dates excluding weekends and holidays.* For the Microsoft documentation refer to support.office.com

 A B 1 =DAYS("07 July 2018","01 July 2018") = 6 1/10/2020 2 =B1-B2 = 9 1/1/2020 3 =DAYS("31/12/2020","1/1/2020") = 365 4 =DAYS("10/1/2020","1/1/2020") = 9 5 =DAYS(1,1) = 0 6 =DAYS(1001,1000) = 1 7 =DAYS(DATE(2016,1,10),DATE(2016,1,1)) = 9 8 =DAYS(DATE(2016,12,31),DATE(2016,1,1)) = 365 9 =DAYS(DATE(2016,1,1),DATE(2016,1,10)) = -9 10 =DAYS(DATE(2016,-1,-1),DATE(2016,-1,-10)) = 9 11 =DAYS(31/12/2020,1/1/2020) = 0 12 =DAYS(-1,-1) = #NUM! 13 =DAYS(DATE(2016,1,"sometext"),DATE(2016,1,1)) = #VALUE!