Skip to main content

DAYS function

The DAYS function is one of the date and time functions. Is used to return the number of days between two dates.

Syntax​

DAYS(end_date, start_date)

The DAYS function has the following arguments:

ArgumentDescription
end_dateend_date and start_date are two dates you wish to calculate the number of days between.
start_dateend_date and start_date are two dates you wish to calculate the number of days between.

Notes​

How to apply the DAYS function.

Examples​

The figure below displays the result returned by the DAYS function.

DAYS Function