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?