Date

S

sonu

How to calculate minimum date from range that is blank and the result displayed should be blank rather than 01/00/0000
 
N

Norman Harker

Hi sonu!

Try:
=IF(COUNTA(A1:A12)=0,"",MIN(A1:A12))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top