Something like:

=IF(AND(TODAY()>A1,TODAY()<B1),1,0)

>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!