John S asks:

I would like to find the dates MM/DD/YYYY missing in a set of date ranges. I haven't been able to find any luck on -line with this.
example:
2/3/2005 - 2/5/2005
2/7/2005 - 2/9/2005
_____________
Missing dates:
2/4/2005, 2/6/2005,2/8/2005

Missing dates

Array formula in cell A6:

=SMALL(IF(COUNTIF($A$2:$B$3, ROW(INDIRECT(MIN($A$2:$B$3)&":"&MAX($A$2:$B$3))))=0, ROW(INDIRECT(MIN($A$2:$B$3)&":"&MAX($A$2:$B$3))), ""), ROW(A1))

Functions in this array formula: SMALL, IF, ROW, INDIRECT and COUNTIF

Find dates between date ranges

Dates between date ranges1

Array formula in cell A6:

=SMALL(IF(COUNTIFS($A$2:$A$3, "<="&ROW(INDIRECT(MIN($A$2:$B$3)&":"&MAX($A$2:$B$3))), $B$2:$B$3,">="&ROW(INDIRECT(MIN($A$2:$B$3)&":"&MAX($A$2:$B$3))))=0, ROW(INDIRECT(MIN($A$2:$B$3)&":"&MAX($A$2:$B$3)))), ROWS($A$1:A1))

Functions in this array formula: SMALL, IF, ROW, INDIRECT and COUNTIFS

Interested in learning more about excel, join my Advanced excel course.

Download excel *.xlsx file

Find missing dates in a set of date ranges.xlsx