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

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.

Please Login or Register  to view this content.

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

Any assistance would be greatly appreciated.

Dave

Try it:

Please Login or Register  to view this content.