IF satement fo in between dates


Y

Yunus

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

=IF($K$5:$BT$138<$IS$1.....
=IF($K$5:$BT$138>$IS$1.....
=IF($K$5:$BT$138=$IS$1.....

Thanks
 
Ad

Advertisements


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

Top