Author: Oscar Cronquist Article last updated on May 09, 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")

Excel 'Date' functions


DATE function
Returns a number that acts as a date in the Excel environment.
DATEDIF function
Returns the number of days, months, or years between two dates. The DATEDIF function exists in order to ensure compatibility with Louts 1-2-3.
DATEVALUE function
Returns an Excel date value (serial number) based on a date stored as text.
DAY function
Extracts the day as a number from an Excel date.
DAYS function
Calculates the number of days between two dates.
EDATE function
Returns a date determined by a start date and a number representing how many months.
EOMONTH function
Returns an Excel date for the last day of a given month using a number and a start date.
MONTH function
Extracts the month as a number from an Excel date.
NETWORKDAYS function
Returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify.
TODAY function
Returns the Excel date (serial number) of the current date.
WORKDAY function
Returns a date based on a start date and a given number of working days (nonweekend and nonholidays).
YEAR function
Converts a date to a number representing the year in the date.
YEARFRAC function
Returns the fraction of the year based on the number of whole days between a start date and an end date.
Excel Function Reference
Provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas.