Link to home
Create AccountLog in
Avatar of shieldsco
shieldscoFlag for United States of America

asked on

Excel convert date to Quarer and Fiscal Year

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)
SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account