Thanks to all that helped me figure this out. I finally
did get it to work, after trying each suggestion. The
suggestion that I found to work was as follows:

=if(and(today()=date(2004,10,15),today()<=date
(2004,10,24)),1,if(and(today()=date(2004,10,25),t oday()
<=date(2004,11,01)),2,if(and(today()=date
(2004,11,02),today()<=date(2004,11,07)),3,if(and(t oday()
=date(2004,11,08),today()<=date(2004,11,14)),4,if (and
(today()=date(2004,11,15),today()<=date(2004,11,2 1)),5,if
(and(today()=date(2004,11,22),today()<=date
(2004,11,28)),6,if(and(today()=date(2004,11,29),t oday()
<=date(2004,12,06)),7,0)))))))))

Thanks Again for everyone's help!

Cindi