Rational
Find the difference between two dates.
Description
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’.
Syntax
=DAYS (end_date, start_date)
Parameters
end_date – The first date of the query.
start_date – The second date of the query.
Return Value
An Integer between 1 to 31.
Key Notes
- 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.
Keep Reading Similar Functions:
DATEDIF
The DATEDIF is an unknown compatibility function that can be used to calculate the difference between two dates. To find years diff.,=DATEDIF(start_date, end_date,”y”).
WORKDAY
WORKDAY function returns a date based on a given number of working days before and after starting date, to find two days after a date excl. weekends,=WORKDAY(date,2) returns 2.
WORKDAYS.INTL
WORKDAYS.INTL returns a working day before and after a date, excl. custom Weekend days i.e. to find a working day 2 days after a date (01-11-2018-B7) excluding Friday and Saturday, =WORKDAY.INTL(B7,2,7), returns ‘05-11-2018’.
DAYS360
The Excel DAYS360 function result assumes that a Year is of 360 days, 30 days per month.
use =DAYS360(“01/05/2017”, “01/08/2018”) that returns ‘450’.
NETWORKDAYS
The NETWORKDAYS function returns a number of working days between two dates, 01-11-2018 (B6) and 31-12-2018 (C6), use =NETWORKDAYS(B6,C6) that returns ‘43’.
NETWORKDAYS.INTL
The NETWORKDAYS.INTL counts days between two dates, excl. custom Weekend days. I.e.; workdays between 01-11-2018 (B6) and 31-12-2018 (C6) excl. Friday and Saturday, use =NETWORKDAYS.INTL(B6,C6,7) that returns 43.