MIN() and MAX() on range with linked values

[Phil Payne]

Hello all.

I want to use =MIN() and =MAX() to find earliest and latest dates in a very large range but cannot get a result, no errors, just empty cells!

The date 'values' in the range are linked entries from another work book which I believe may be the cause of the problem.

Is that the problem and is there a way to get around it?

Thanks,

Phil.

 

[Phil Payne]

I have noticed that it is the MIN that is the problem. MAX is ok.

Is that because the range contains numerous empty cells?

Can the MIN formula be written to return the second earliest date in the range?

('SMALL' and 'LARGE' behaves the same)

 

[Phil Payne]

I had looked through our forum but only found the answer after I posted the question.
I had to make my formula an array and change it
from:
=MIN(G15:BE145,1)
to:
=MIN(IF(G15:BE145,G15:BE145))
Regards all.
Phil