Roger,

I haven't spotted the thread you mentioned in worksheet.functions, but
wouldn't your formula need to look more like
="Q"&CEILING(MOD(MONTH(B9)+5,12)+1,3)/3
if it were to satisfy the OPs's description?
--
David Biddulph

"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message
...
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?

--
Regards
Roger Govier

"bee" wrote in message
...
i have two columns
col a col b
q3 2/2/07
q2 10/12/06
I have 4 quarters in a financial year jul-sep, oct-dec, jan-mar and
apr-jun
is there a formula I can enter in col a so that when I enter date in col
b
then correct quarter will come up in col a
Thank you for your assistance