Author: Oscar Cronquist Article last updated on May 21, 2022

The DATE function calculates the number of days between two dates.

Formula in cell D3:

=DAYS(B3,C3)

Excel Function Syntax

DAYS(end_date, start_date)

Arguments

end_date Required. The end date of the date range you want to calculate.
start_date Required. The start date of the date range you want to calculate.

Comments

You can also use dates as text values, example:

=DAYS("4/11/2019","1/1/2013")