Dates in a Financial Year
="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?
|