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
 

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

Similar Threads

HELP: IF Statement between Dates for Reverse Index failing 0
Reverse INDEX MATCH 0
CTRL SHIFT ENTER 2
Show value from one cell in another cell if today falls between a date range 5
checking for positive or negative numbers 1
Help with an if then scenario 2
Formula for Dates and CF Colour then convert to Text 3
VB code. If statement between two values 1

Top