=IF(AND(C6=--"4/2/2007",C6<=--"4/26/2007"),"April","Move On)


--
Regards,

Peo Sjoblom



"DP7" wrote in message
...
My formula is not working. I need a formula that says: I cell c2 falls
between 4/2/2007 and 4/26/2007 then insert April, if not insert Move on. I
actual need to create date ranges for each month. If I can get this
working I
can build the rest myself. If there is a better way of doing this I would
be
happy for your help. Thanks in advance
=IF(AND(C6="4/2/2007",C6<="4/26/2007"),"April","Move On") this is my
formula that is not working correctly.