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