Find the difference between two dates.
The Excel DAYS function returns difference between two dates. Example; to calculate days duration between two dates, use =DAYS(“01/08/2018″,”01/05/2017”) that returns ‘457’.
=DAYS (end_date, start_date)
end_date – The first date of the query.
start_date – The second date of the query.
An Integer between 1 to 31.
- In DAYS start_date need not to be less than end_date like DATEDIF function although the result will be negative in that case.
- The DAYS360 function is useful for 360 days calendar only.
- The return value format of DAYS function should ideally be in a number or a general format.
- We can calculate the same result by simple subtraction. So rather than DAYS function, we can find the same value by subtracting to dates.
- DAYS function is suitable in case user want to enter dates enclosed in a double quote manually. Although I doubt anybody would like to opt for such kind of time taking the option.
- Excel DAYS function was introduced in the 2013 Excel release.