Thank you - it worked perfectly. I would have never gotten there on my own.

"Gary''s Student" wrote:

try:

=CHOOSE(MONTH(A1),1,1,1,2,2,2,3,3,3,4,4,4) & "Q" & RIGHT(YEAR(A1),2)

--
Gary''s Student - gsnu200835


"Anna Wood" wrote:

I have a list of dates extending out for the next 8 years and I need to put
them in the quarter/year category - i.e., 3Q09 for a date that is 10/12/09.

Is there a formula to convert dates to this type of format?