Return text instead of 00/01/1900 as result of formula

[creative999]

My formula for displaying the last date kind of works. However, if there are no "AC" values in column B, then it returns a 00/01/1900 value. How can i amend the formula below to show some text in this case?

=MAX(IF(C8:C5000="AC",E8:E5000))

 

[DanteAmor]

May be:

=IF(COUNTIF(C8:C5000,"AC"),MAX(IF(C8:C5000="AC",E8:E5000)),"Not exists")

 

[creative999]

May be:

=IF(COUNTIF(C8:C5000,"AC"),MAX(IF(C8:C5000="AC",E8:E5000)),"Not exists")

Perfect. Thank you so much.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.