Hi,

Type this in range C9:C12 - 2,5,8,11. Type this in range D9:D12 - Qtr 3,Qtr
4,Qtr 1,Qtr 2. Assuming your date in cell B15, in cell C15, you may use the
following formula

=VLOOKUP(MONTH(B15),$C$9:$D$12,2)&",
"&IF(MONTH(B15)<8,YEAR(B15)-1,YEAR(B15))

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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?