Returning most recent dates with conditions where some fields are blank

Currently I have a spreadsheet that returns the earliest and latest date matching a certain criteria. How could I have the below formula ignore the blank fields which have been returning 1/0/1900. Any help is appreciated.

{=MIN(IF($A$2:$A$14=D2,$B$2:$B$14, " "))}

blankvalues.xlsx

blankvalues.png

Hi

How about

Please Login or Register  to view this content.

Array entered of course....

rylo

Thanks for the help.