Returns the number of days between the specified dates.

Syntax  Copy Code
DAYS( Date endDate, Date startDate ) → Number

Parameters

endDate

Required. The end date of the interval.

startDate

Required. The start date of the interval.

Example

Formula  Copy Code
=DAYS(TODAY(),DATE(2013,1,1))

See Also

Function Reference
DAYS360 Function
DATEDIF Function
YEARFRAC Function