For business users of Microsoft Excel Free guides and templates
Home >  Excel Help >  Excel Functions >  

Date and time

DAYS Function

Returns the number of days between two dates


by Charley Kyd, MBA
Microsoft Excel MVP, 2005-2014
The Father of Spreadsheet Dashboard Reports

It's not clear why the DAYS function exists, because you can easily use the INT function to yield the same results. See examples #2 and #5 below.

Syntax

DAYS(end_date,start_date)

  • end_date  Required. The end date with which to calculate the elapsed days.

  • start_date  Required. Required. The starting date with which to calculate the elapsed days. It can be the date-time code that Excel uses for date and time calculations. It also can be text that the DATEVALUE function could convert into a date serial number.

Note that both dates can take two forms. They can be the date code that Excel uses for date and time calculations. They also can be text that the DATEVALUE function could convert into a date serial number.

Applies To

Excel 2013 and above

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Examples of the DAYS worksheet function.

Other Help

 

Charley's SwipeFile charts


Free Excel Dashboards