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.