DAYS

Find the difference between two dates in Excel
Returns the number of days between two dates

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:

Determine the difference between two dates in Excel

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

Read More »
Get Nth working day before and after a given date in Excel

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.

Read More »
Find a number of working days between a date range in Excel

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

Read More »
Find a number of working days between a date range in Excel

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

Read More »
Find a number of working days with custom weekend days in Excel

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.

Read More »
Find the difference between two dates, based on a 360 days year cycle in Excel.

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

Read More »