I want to have a calculated column that does the following: If Created is between 1/1/11 and 4/1/11, Output "Quarter 1 2011". This will become a nested ELSE to have every quarter for the next few years, but I figured I'd simplify here. I'm able to do it if I use 2 extra columns to define 1/1/11 and 4/1/11 by using the below: =IF(AND(Created>[Begin Q1],Created<[Begin Q2]),"Quarter 1 2011","None")) It seems silly to have to use the extra columns, though. How can I just define the dates within the calculated column?

Hi cjnolen, Try this on for size. One calculated column: =CONCATENATE("Quarter ",ROUNDDOWN(((INT(MONTH([Created]))-1)/3),0)+1, " ",TEXT(YEAR([Created]),"000")) - Xenox G.- Xenox G.

OK, that worked beautifully! It took me a bit to figure out the logic.