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