Help with MS Excel

[PeterGriffin]

I need a function!

In cell A1 I have a date.
In cell B1 I want it to analize the data in A1 and output a "1" if the date is between 01/01/03 and 02/01/03 otherwise if false write "0".

How would I write this formula?


The formulas I see all only allow you to do one logical test. In this case I'm wanting to do two logical tests, aren't I?


PLEASE HELP

[BitSpit]

This formula should do it. The key to making it work is to format your date cell as text. If you don't, it returns the VALUE error.

=IF(DATEVALUE(A1)>=DATEVALUE("01/01/03"),IF(DATEVALUE(A1)<=DATEVALUE("02/01/03"),1,0),0)

[PeterGriffin]

That works great buuuutttt.
When I format my already "date formated" cells into "text format" the numbers go all crazy.

How can I maintain my dates when I format to text?

[BitSpit]

When I created that, Excel decide to be a little screwy. This revised formula will do it without requiring reformating the cells.

=IF(A1>=DATEVALUE("01/01/03"),IF(A1<=DATEVALUE("02/01/03"),1,0),0)