Roughly the same idea, but implemented in a slightly different way (one function call less)...

="Qtr "&(1+MOD(INT((MONTH(A4)+4)/3),4))&", "&(YEAR(A4)-(MONTH(A4)<8))

Just as an alert to the OP, your formula omitted a couple of "neatening" spaces (which can easily be added, of course) that the OP's examples showed he apparently wanted.

--
Rick (MVP - Excel)


"Bob Phillips" wrote in message ...
="Qtr"&MAX(1,INT((MOD(MONTH(A1)+4,12)+3)/3))&","&YEAR(A1)-(MONTH(A1)<8)

--
__________________________________
HTH

Bob

"Kurt" wrote in message
...
If I have a financial year August01-July31, is there a worksheet
function(s)
which I can use to convert date such as 22/08/09 to read 'Qtr1, 2009' or
23/03/10 to read 'Qtr 3, 2009' etc. Any advice?