Array formula in A2:
Copy cell A2 and paste it down as far as needed.
What is named ranges?
How does this formula work?
You find an explananiton here: Convert date ranges into dates in excel
Download excel sample file for this tutorial.
Filter overlapping dates from date ranges.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE
SMALL(array,k) returns the k-th smallest row number in this data set.
Returns the smallest number in a set of values. Ignores logical values and text
ROW(reference) returns the rownumber of a reference
Calculates how often values occur within a range of values and then returns a vertical array of numbers having one more element than Bins_array.
Returns a reference to a range that is a given number of rows and columns from a given reference