I have two columns containing dates. What I want to do is add a third column, and have that column have a value of 1 if a date I specify is between the two dates in the columns.

Something like:

If "6/20/2006" is between DateColumnLower and DateColumnUpper, Return 1

Thanks for any help!