It's got to be something simple IF AND...

Hi Folks

Sorry if this turns out to be something really simple, just overloaded I think.

What I'm trying to do is:

If cell Q31 is empty, do nothing. If it has a date in it, check that date against TODAY(). If there are between 30 and 89 days return "Yes", if it's more than 89 days return "No"

I hope someone can tell me where I'm going wrong....

=IF($Q31="","",IF(AND(TODAY()-Q31>30<89),"Yes","No"))

Thank you..

Kind regards

DezB

Hi AliGW

You star, thank you so much..

Kind regards

DezB