My company's fiscal year runs from April through March.
So I would like to take a date, say in A1, and convert to Quarter in column B.
i.e., 4/1/2010 - 6/30/2010 = Q111
7/1/2010 - 9/30/2010 = Q211
10/1/2010 - 12/31/2010 = Q311
1/1/2011 - 3/31/2011 = Q411
I have read several posts and threads and tried various formulas..with partial success. Thank you for any guidance on this.

Brian