Use AND function as follows:-
=If(and(today()"10/15/04",today()< "10/24/04"),1,if(and(....
"Cindi" wrote in message
...
Is there an "Is Between" function? I want to say the
following, but I don't know how.

If Today() is between "10/15/04" and "10/24/04", then 1,
but if today() is between "10/25/04" and "11/01/04", then
2....and so on, and so on, and so on....

How do I do this??? Please help!

Thanks,

Cindi