Menu
EXCEL DAYS FUNCTION
Excel DAYS Function Introduction
This function returns the number of days between two dates. This function is available from Excel 2013 and Excel for Mac 2011.
Description of Excel DAYS Function
Syntax:
=DAYS(end_date, start_date)
Parameter list:
end_date – the end date.
start_date – the start date.
Step By Step Guide of DAYS Function
In this example we have calculated the number of days between two dates. You can see we are getting the #NUM value error when the range falls outside and #VALUE error when we try to compare the date and text.
Key Points
If either one of the date arguments is text, that argument will be treated as DATEVALUE(date_text) and returns an integer date.
If date arguments are numeric values that fall outside the range of valid dates, DAYS returns the #NUM! error value.
If date arguments are strings that cannot be treated as valid dates, DAYS returns the #VALUE! error value.
If you want to directly enter the dates like this =DAYS(“22/05/2015”,“20/05/2015”) then you must enclose the dates in quotation marks.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
