DAYS(end_date, start_date)

Returns the number of days between two dates.

end_dateThe date that represents the finishing date.
start_dateThe 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

 AB
1=DAYS("07 July 2018","01 July 2018") = 61/10/2020
2=B1-B2 = 91/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! 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top