Shane Devenshire wrote...
....
=MIN(IF(DATE(YEAR(A$2:A$10),MONTH(A$2:A$10),DAY(A $2:A$10))=E1,A$2:A$10,""))

=MAX(IF(DATE(YEAR(B$2:B$10),MONTH(B$2:B$10),DAY(B $2:B$10))=E1,B$2:B$10,""))
....

Why not just

=MIN(IF(INT(A$2:A$10)=E1,A$2:A$10))

and

=MAX(IF(INT(B$2:B$10)=E1,B$2:B$10))

?