between formula

[tkaplan]

is there any formula (I cannot use a macro for this) that I can put in that checks if a date is between two dates?

i tried doing
if(date>5/15/2005 and date<8/16/2005,"y","n")
but this does not work.
i know that i can do a nested if but i'm trying to stay away from that because this is already the fourth level of a nested if statement.

any assitance would be greatly appreciated.

[swatsp0p]

Try imbedding the AND function within your IF statement, such as:

=IF(AND(B1>4,B1<6),"In Between","Not In Between")

a value of 5 in B1 will return "In Between"

HTH

Bruce

[tkaplan]

that works. Thank you.

another question:
how do i compare the date
say i want to do

if(a1<5/15/2005)

it's not treating 5/15/2005 as a date.
How can I get it to do that?

[swatsp0p]

Try this:

if(a1<DATE(2005,5,15) the Date function use format (yyyy,m,d)

HTH

Bruce

[tkaplan]

thank you.