I'm using the formula below to convert dates to fiscal quarter and fiscal year. The fiscal begins on 10/1 which is the first quarter. The formula is only converting the forth quarter of the fiscal. The output should be in the following format : Q4-2016
Any advice how to convert. Thanks
=IF(MONTH(D4)<=9,CHOOSE(MONTH(D4),"Q2","Q2","Q2","Q3","Q3","Q3",
"Q4","Q4","Q4","Q1","Q1","Q1")&"FY"&YEAR(D4),"FY"&YEAR(D4)+1)