quarter
 

How to display what quarter a date falls in?

03/24/2009 = "Q1"

quarter
 

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

"Kent Prokopy" <kent wrote in message
...
How to display what quarter a date falls in?

03/24/2009 = "Q1"

quarter
 

Try

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

Mike

"Kent Prokopy" wrote:

How to display what quarter a date falls in?

03/24/2009 = "Q1"

quarter
 

If you want the Q to display

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

Mike


"Mike H" wrote:

Try

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

Mike

"Kent Prokopy" wrote:

How to display what quarter a date falls in?

03/24/2009 = "Q1"

quarter
 

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