Hi

=IF(AND(B34=DATE(2004,11,1),B34<=DATE(2005,1,31)) ,"Q1",IF(AND(B34=DATE(2005,2,1),B34<=DATE(2005,4, 30)),"Q2",""))

Regards

Roger Govier


TLB wrote:
HI,
I'm trying to create the following formula:

if cell b34 is between Nov 1/04 and Jan 31/05, enter "Q1"
if cell b34 is between Feb 1/05 and April 30/05, enter "Q2"

etc.
What is the correct syntax for this formula? I have entered:

if(11/01/04<=b34<=01/31/05,"Q1",if(02/01/05<=b34<=04/30/05,"Q2",if(etc etc)))

But this isn't working.

Does anyone know how to create an If statement based on a cell falling
within a range of dates?