This function calculates the number of days between two dates.

Syntax

DAYS(end_date, start_date)

Arguments

Specify the end_date and start_date argument as a number (as in 37806), a string or reference to cells containg the information.

Data Types

Accepts numeric or string data for both arguments. Returns numeric data.

Examples

DAYS("5/15/11","4/1/11") gives the result 44.