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!!
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!!