Need assistance with IF formula

Good Afternoon,

I have the formula below:

=IF(ISBLANK(J2530),"",IF(J2530<TODAY(),TODAY(), J2530))

Which works perfectly. If the date in Cell J2530 is before todays date, it shows up as todays date.

Now, my problem begins, I need to run the same formula, but also have it so that if the word "DUE" is in Cell H2530 it reads todays date.

I have the bodged the formula below, but alas it doesnt work.

Can anybody assist in making the magic happen

=IF(ISBLANK(J2525),"",IF(J2525<TODAY() OR(IF(ISERR(SEARCH("DUE",H2525)),TODAY(), J2525)))

Many Thanks
Ross

Both worked.

Thanks both!!!

Greatly Appreciated!

Can the code be altered for the Cell to be blank if H2517 contains "PROFORMA" "TBC" OR "YES"

=IF(ISBLANK(J2517),"",IF(OR(H2517="DUE",J2517<TODAY()),TODAY(), J2517))

Thanks
Ross