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.