Return blank instead of 1/00/00

[thanksamillion101]

Hello, I have spent enough time on this WS and ready to have it completed and appreciate all help! The formula I need in (Z11) is to return "blank", instead of 1/00/00. The formula I am using will return the Max date between two ranges. Greater than 1/1/22 and less than 9/30/22 (A1)...if Max (N11:Y11) is greater than 9/30/22, then blank otherwise, Max between original range. Thank you!!

 

[AhoyNC]

Try:
=IF(SUM((N11:Y11<=$A$1)*(N11:Y11>=DATEVALUE("1/22/2022")))=0,"",MAX(IF((N11:Y11<=$A$1)*(N11:Y11>=DATEVALUE("1/22/2022")),N11:Y11)))

 

[bebo021999]

=IF(AND(MAX(N11:Y11)<=$A$1,MAX(N11:Y11)>=DATE(YEAR($A$1),1,1)),MAX(N11:Y11),"")

 

[thanksamillion101]

Try:
=IF(SUM((N11:Y11<=$A$1)*(N11:Y11>=DATEVALUE("1/22/2022")))=0,"",MAX(IF((N11:Y11<=$A$1)*(N11:Y11>=DATEVALUE("1/22/2022")),N11:Y11)))

Works perfectly, Thank you!!

 

[thanksamillion101]

=IF(AND(MAX(N11:Y11)<=$A$1,MAX(N11:Y11)>=DATE(YEAR($A$1),1,1)),MAX(N11:Y11),"")

Works perfectly, Thank you!!