Albert H. Bell wrote...
I have the same problem with your formula. *If the Int Formula contains more
than 1 date I return #Value.

"Harlan Grove" wrote:
....
=MIN(IF(INT(A$2:A$10)=E1,A$2:A$10))
....
=MAX(IF(INT(B$2:B$10)=E1,B$2:B$10))

Then you didn't enter the formula as an array formula. To do so, you
need to hold down a [Ctrl] key and a [Shift] key before pressing the
[Enter] key.