quarter

[Kent Prokopy]

How to display what quarter a date falls in?

03/24/2009 = "Q1"

 

[Ashish Mathur]

Hi,

Use this formula. I have assumed that the date is in cell C6.

="Q"&IF(MOD(MONTH(C6),3)=0,MONTH(C6)/3,INT(MONTH(C6)/3)+1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Mike H]

Try

=ROUNDUP(MONTH(A1)/3,0)

Mike

 

[Mike H]

If you want the Q to display

="Q"&ROUNDUP(MONTH(A1)/3,0)

Mike

 

[Bernd P]

="Q"&INT((MONTH(A1)+2)/3)