Using Mutiple IF statements with AND

[Melo]

Hello,

I am trying to use this formula:

=IF(AND(C753>=10/01/2012,C753<=12/31/2012),"Qtr 1",AND(C753>=01/01/2013,C753<=3/31/2013),"Qtr 2",AND(C753>=04/01/2013,C753<=06/30/2013),"Qtr 3",AND(C753>=07/01/2013,C753<=09/30/2013),"Qtr 4","N/A")

I know that the "AND"s are screwing everything up, but I cannot think of another way to make the quarter self-populate based on the date in another column. Any help would be greatly appreciated!!

 

[Special-K99]

Try
=IF(C753>DATEVALUE("07/01/2013"),4,IF(C753>DATEVALUE("04/01/2013"),3,IF(C753>DATEVALUE("01/01/2013"),2,IF(C753>DATEVALUE("31/12/2012"),1,"na"))))

 

[njimack]

="Qtr "&CHOOSE(MONTH(C753),2,2,2,3,3,3,4,4,4,1,1,1)

 

[Melo]

That worked beautifully!! Thank you!