IF satement fo in between dates



Cell IP1= Today()
Cell IS1= Today()+14
Cell IU1= Today() +35

I wish to create a two If statements where the Criteria is if it fall
in between
1)IS1 & IP1 i.e in between Today and 14 days
2)IS1 & IU1 i.e in between 14 days and 35 days

I know how to do greater, smaller or equal as shown below but how do I
do the in between command for the above sceanarios.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question