Related Function:

The DAYS function returns the number of days between two supplied dates.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.

Syntax

=DAYS(start_date,end_date)

Arguments

Argument Description
start_date The start date
end_date The end date

The start_date and end_date arguments for the DAYS function should be input as either:

  • A reference to a cell containing a date or,
  • A date returned from another function or formula

Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.

Examples

  A B C D
1 Start date End date Formula Result
2 Thu 01-Jan-2015 Mon 02-Feb-2015 =DAYS(B2,A2) 32

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if one or both of the supplied start_date and end_date arguments are text values that can not be interpreted as dates
#NUM! Occurs if one or both of the supplied start_date and end_date arguments are numeric values, but are not recognized as valid dates