Array formula returning 00-Jan-00 instead of blank cell

[Motox]

Hi forum,

I have an array formula that finds the latest date in a range or returns a blank cell if no date is found. This works very well.

The problem I have is that it sometimes returns 00-Jan-00 and this seems to occur when the value in D2 is not in the range A2:A30000. What I need it to do in these instances is to return a blank cell instead.

I have tried replacing the last zero in the formula with " " but it still returns 00-Jan-00.

=IF(SUMPRODUCT(($A$2:$A$30000=D2)*($B$2:$B$30000=""))>0,"",MAX(IF($A$2:$A$30000=D2,$B$2:$B$30000,0)))

How can I get a blank cell instead of 00-Jan-00?

Any assistance would be greatly appreciated.

Dave