ExcelBanter - If + date range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If + date range (https://www.excelbanter.com/excel-worksheet-functions/142031-if-date-range.html)

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.

=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.