I have tried this formula but it still does not work.
Col a Col B
Q3 1/02/2007
Q3 2/12/2006
Q3 3/09/2006
Q3 5/4/2007
I entered ="Q"&CEILING(MONTH(DATE(2007,MONTH(A11=6,1)),3)/3
but it gave Q3 and the A11 changed to A12,a13 etc
so I tried $a$11 but still gave Q3 on all lines

Thank you.

"JE McGimpsey" wrote:

Given that the OP wanted the fiscal year to start in July, if the
previous answers were like the one you just posted, they probably didn't
work...

One modification:

="q"&CEILING(MONTH(DATE(2007,MONTH(A11)+6,1)),3 )/3

In article ,
"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote:

Hi

You posted this question in worksheet functions on 6th Oct.
You had several answers then, including my response of

="Q"&CEILING(MONTH(B1),3)/3

Did they not work for you?