If + date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Combining an IF with another formula 4
Why doesn't this work ? 2
WORKDAY resulting in #VALUE error 3
COUNTIFS 3
Sumif & Dates 4
mortgage ammortization schedule 7
Consolidation if a least one criteria is met 4

Back
Top