K
Kent Prokopy
How to display what quarter a date falls in?
03/24/2009 = "Q1"
03/24/2009 = "Q1"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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
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
M
Mike H
Try
=ROUNDUP(MONTH(A1)/3,0)
Mike
=ROUNDUP(MONTH(A1)/3,0)
Mike
M
Mike H
If you want the Q to display
="Q"&ROUNDUP(MONTH(A1)/3,0)
Mike
="Q"&ROUNDUP(MONTH(A1)/3,0)
Mike
B
Bernd P
="Q"&INT((MONTH(A1)+2)/3)