Deriving the quarterly period from a date

[FJMD1003]

Hi all,

I'm looking to use a date value to drive a formula that will return the quarterly period that the date falls into. I'm defining the quarters as such:

Quarter 1: Jan-March
Q2: April - June
Q3: July-September
Q4: October - December

It will also have to reference the year of the quarter, e.g. if date is 01/01/2012 formula would return Q1 2012 or for 01/01/2011 Q1 2011. Dates are UK format.

Any ideas? Can I do this through some clever cell formatting? Or do I need to crunch an unwieldy formula?

Many thanks for the help,

Fred

 

[VoG]

Try

="Q"&LOOKUP(MONTH(A1),{1,4,7,10},{1,2,3,4})&" "&YEAR(A1)

 

[FJMD1003]

Peter - not only was that response super quick but totally correct - thanks so much! Greatly appreciated!

Fred

 

[JackDanIce]

This should work:

="Q"&MATCH(MONTH(A1),{1,4,7,10},1)&" "&YEAR(A1)