Stop MIN(IF error if no date is in date range

[ArcticAce]

I need help to stop this formula =MIN(IF(K10:N10>TODAY(),K10:N10)) from returning 1/0/1900. I would like the formula to return a blank, or "Recommendation Needed", if all dates are before today.

Thanks in advance for any assistance.

 

[shuvodey]

Hi,

Does wrapping your formula in another IF not solve the issue? E.g. =IF(MIN(IF(K10:N10>TODAY(),K10:N10)), "","Recommendation Needed")

 

[MARZIOTULLIO]

=IF(MIN(IF(K10:N10>TODAY(),K10:N10))=0,"Recommendation Needed",MIN(IF(K10:N10>TODAY(),K10:N10)))

Control +Shift+ Enter

 

[ArcticAce]

Thanks shuvodey, and MARZIOTULLIO for your assistance. I used MARZIOTULLIO formula, and it worked.