DAYS

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.

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’.

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’.

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.

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.

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’.

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”).