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....


    Thank you..

    Kind regards


  • Try this:


    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!