$B$1 - end of the first interval
$A$1 - start of the second interval
$B$2 - end of the first interval
$A$2 - end of the second interval
=MAX(MIN($B$1, B2) - MAX($A$1, A2) + 1, 0)
2013-12-03
Excel: get number of days in overlapping intervals/dates
The following Excel formula calculates how many days overlap in two intervals.
$B$1 - end of the first interval
$A$1 - start of the second interval
$B$2 - end of the first interval
$A$2 - end of the second interval
=MAX(MIN($B$1, B2) - MAX($A$1, A2) + 1, 0)
$B$1 - end of the first interval
$A$1 - start of the second interval
$B$2 - end of the first interval
$A$2 - end of the second interval
=MAX(MIN($B$1, B2) - MAX($A$1, A2) + 1, 0)
Labels
Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment