Formula to convert date to Quarter

[Ecel Dumbo]

Hi,

I am having trouble converting month to Quarter

If you see example below. Jun-13 is Quarter 2-13
Jul -13 should be Q3-13 and not as shown below

Formula i am using is ="Q"&INT((MONTH(A1)/3)+0)&"-"&RIGHT(YEAR(A1),2)
Please advise what went wrong

Jun-13 Q2-13
Jul-13 Q2-13 WRONG
Aug-13 Q3-13
Jun-14 Q2-14
Jul-14 Q2-14 WRONG
Sep-14 Q3-14
Oct-14 Q3-14 WRONG

 

[Ecel Dumbo]

Sorry the formula used is "Q"&INT((MONTH(A1)/4)+1)&"-"&RIGHT(YEAR(A1),2)

please help point out what went wrong

 

[Khalid NGO]

Hi,
See if this works:

="Q"&CEILING(MONTH(A1)/3,1)&"-"&RIGHT(YEAR(A1),2)

Regards,

 

[Ecel Dumbo]

Thanks Khalid, it worked

 

[Khalid NGO]

Thanks Khalid, it worked

Glad.

You are welcome dear, keep visiting.