DAYS
Description
Returns an integer representing the number of days between two specified dates.
Syntax
DAYS(
end_date
, [
start_date
])
- end_date: The ending date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- start_date: The starting date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
Example
Formula | Result |
|---|---|
=DAYS("01-Jan-2015", "10-Jan-2015") | -9 |
=DAYS("01-Dec-2016","14-Jul-2016") | 140 |