I'm doing this for a calendar quarter as opposed to a fiscal quarter. I'm
not sure of your fiscal calendar.

=IF(MONTH(A2)=10,"Q4",IF(MONTH(A2)=7,"Q3",IF(MON TH(A2)=4,"Q2","Q1")))

"Andrew" wrote:

Is there a way to convert dates into their respective fiscal quarters. For
instance, if A2 = 10/15/07, I want A3 = Q3.