DAYS Function

DAYS function in Excel

About

The Excel DAYS function is a DATE & TIME function that can return the number of days between two dates.

Purpose

Find the number of days between two dates

Return value

An integer representing the number of days

Syntax

=DAYS (end_date, start_date) 

Arguments

end_date РThe end date

start_date РThe start date


Examples

Number of days between two Dates (Direct Values)

The following formula will return the number of days between the two dates 01/01/2000 and 31/01/2018

=DAYS("01/01/2000","31/01/2018")

Number of days between two Dates (cell references)

The following formula will return the difference between the two dates in the cells C3 and B3.

=DAYS(C3,B3)

Notes

When the smaller date is used as first argument (start_date) function will return a negative value.

DAYS function will ignore the time part (decimal) of dates in Excel.


Read about

DATE and TIME in Excel

TODAY Function

NOW function

SORT function

SEQUENCE function

SORTBY function

RANDARRAY function

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.