DAYS function in Excel

Syntax

=DAYS(end_date, start_date)

Example

=DAYS(C2,B2) is shipped date minus ordered date.

From the lesson DAYS Function.

Common mistakes

• Reversing the arguments, which gives a negative number.
• Using DAYS on text that only looks like a date.

Related date functions

• DATEBuilds a date from year, month and day.
• TODAYReturns today's date.
• DATEDIFDifference between two dates in "Y", "M" or "D".
• EDATEDate a number of months before or after.
• EOMONTHLast day of the month, months away.
• WORKDAYDate a number of working days away.
• YEARReturns the year of a date.
• MONTHReturns the month of a date.