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