Yes you are right. I havent noticed that..

="Qtr "&LOOKUP(--TEXT(A1,"m"),{1,2,5,8,11},{2,3,4,1,2}) & " " &
YEAR(A1)-(--TEXT(A1,"m")<8)

If this post helps click Yes
---------------
Jacob Skaria


"Sam Wilson" wrote:


LOOKUP(--TEXT(A1,"mm"),{1,2,5,8,11},{2,3,4,1,2}) is a much better way of
doing it than my way, but TEXT(A1,"yyyy") won't work as 23/03/10 is in
financial year 2009, so you'll need the if(month(A1)...) still.


"Jacob Skaria" wrote:

With your date in cell A1; try the below formula

="Qtr"&LOOKUP(--TEXT(A1,"mm"),{1,2,5,8,11},{2,3,4,1,2}) & TEXT(A1," yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"Kurt" wrote:

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?