### 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.* The arguments are back to front, the end_date comes before the start_date.* 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.* Dates can start from 1st January 1900 up to 31st December 9999.* You can use the DATE function to return the date serial number given a year, month, day.* You can use the DAY function to return the day as an integer given a date serial number.* 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.microsoft.com

 A B 1 =DAYS("07 July 2020","01 April 2020") = 97 Friday, January 10, 2020 2 =B1-B2 = 9 Wednesday, January 01, 2020 3 =DAYS("10 January 2020","01 January 2020") = 9 4 =DAYS("31/12/2020","1/1/2020") = 365 5 =DAYS("10/1/2020","1/1/2020") = 9 6 =DAYS(1,1) = 0 7 =DAYS(1001,1000) = 1 8 =DAYS(DATE(2016,1,10),DATE(2016,1,1)) = 9 9 =DAYS(DATE(2016,12,31),DATE(2016,1,1)) = 365 10 =DAYS(DATE(2016,1,1),DATE(2016,1,10)) = -9 11 =DAYS(DATE(2016,-1,-1),DATE(2016,-1,-10)) = 9 12 =DAYS(31/12/2020,1/1/2020) = 0 13 =DAYS(-1,-1) = =DAYS(-1,-1) 14 =DAYS(DATE(2016,1,"sometext"),DATE(2016,1,1)) = =DAYS(DATE(2016,1,"sometext"),DATE(2016,1,1))

 1 - How many days are there between "07 July 2020" and "01 April 2020".2 - How many days are there between "10 January 2020" and "01 January 2020".3 - How many days are there between "10 January 2020" and "01 January 2020".