DAYS Function
Excel DAYS Function
Summary
The Excel DAYS function returns the number of days between two dates. With a start date in A1 and end date in B1 =DAYS(B1,A1) will return the days between the two dates.
Right click on the Result
cell, where apply the formula, select Format Cell
Click Format Cells to open
the Dialog box and select Date from Custom
Click OK. The number will
change into date
Purpose
Get days between dates
Return value
A number representing days.
Syntax
=DAYS (end date, start date)
Arguments
·
end
date - The end date.
·
start
date - The start date.
Usage notes
The DAYS function returns the number of
days between two dates.
=DAYS(A2,A1)
Will return the same result as:
=A2-A1
Unlike the simple formula above, the DAYS function can also handle dates in text format as long as the date is recognized by Excel. For example:
=DAYS("7/15/2016","7/1/2016")
// returns 14
The DAYS
function does not take into account any time value that's part of the date.
Recommended Articles
Comments
Post a Comment