Multiple Formulas in one Cell

[zakasnak]

Here are my three formulas:

in R6: =IF(K6="","",CHOOSE(MONTH(K6),2,2,2,3,3,3,4,4,4,1,1,1))
in Q6: =IF(K6="","",YEAR(K6)+IF(MONTH(K6)>=10,1,0))
in P6: =IF(Q6="","",("Q"&R6&" "&"FY"&Q6))

R6 finds the Fiscal Quarter of the date in K6
Q6 finds the Fiscal Year of K6
P6 combines the two results into the format I desire.

I would like to combine the three formulas into one that I can put into P6 for the result : Q3 2015.

Help?

 

[Jonmo1]

Try

="Q"&CEILING(MONTH(EDATE(K6,3))/3,1)&TEXT(EDATE(K6,3)," ""FY""yyyy")

 

[zakasnak]

PERFECT! Thank you!

 

[Jonmo1]

You're welcome.