G Guest Apr 9, 2004 #1 How to calculate minimum date from range that is blank and the result displayed should be blank rather than 01/00/0000
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 Apr 9, 2004 #2 Hi sonu! Try: =IF(COUNTA(A1:A12)=0,"",MIN(A1:A12)) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi sonu! Try: =IF(COUNTA(A1:A12)=0,"",MIN(A1:A12)) -- Regards Norman Harker MVP (Excel) Sydney, Australia (e-mail address removed) Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
