If you want it to go on and on it will get messy! Here is the formula
for "is it between two dates" returning 1 if it is and 0 if it isn't.
(you could replace the 0 with the formula repeated for a second set of
dates and so on)

=if(and(today()=date(2004,10,15),today()<=date(20 04,11,01)),1,0)

However is there a pattern to your start and end dates as this might
allow a simpler method?


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=275344