DAYS Function

Basic Description

The Excel DAYS function returns the number of days between two supplied dates. This function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

Syntax: DAYS( start_date, end_date )

Note that the supplied start_date and end_date arguments should be input as either references to cells containing dates or dates returned from formulas. If you attempt to input the start_date and end_date as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.

 

DAYS Function Example

The following spreadsheet shows a simple example of the Excel DAYS function.

 Formula:
A B
1 01/01/2015 =DAYS( A2, A1 )
2 02/02/2015
 Result:
A B
1 01/01/2015 32
2 02/02/2015

 

 

DAYS Function Errors

#NUM! – Occurs if one or both of the supplied start_date and end_date arguments are numeric values, but are not recognised as valid dates.
#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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment