"Cindi" wrote...
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....

There are different numbers of days between 10/15/04 and 10/24/04 - 10 days
including both the 15th and the 24th - and between 10/25/04 and 11/01/04 - 8
days inclusive. If your periods span different numbers of days, the best
approach is using LOOKUP. Something like

=LOOKUP(TODAY(),--{"10/15/04";"10/25/04";"11/02/04";"11/20/04"},
{1;2;3;4})