MIN IF function searching for date, ignoring blank cells

[Gijs]

Hope someone can help me,

I'm trying to identify the earliest date in the month (of January) from a range ($J$13:$J$320).

• =MIN(IF(1=MONTH($J$13:$J$320),$J$13:$J$320,"")) (Ctr+Shift+Enter).

It works like a charm, as long as the range doesn't contain a blank cell, which it does.

• =MINA(IF(1=MONTH($J$13:$J$320),$J$13:$J$320,"")) yields the same false result: Jan 00 '00
• =MINIFS formula is not an option; its not on my Excel 2011

Can anyone help me with my MIN IF a formula searching for date, ignoring blank cells?

Thanks in advance,
Gijs

 

[Gijs]

IF did the trick Peter, wonderful, thanks.
And thank you Jack for brokering.

 

[Peter_SSs]

IF did the trick Peter, wonderful, thanks.

You're welcome. Glad it helped.