formula to convert month to quarter

[lejanco]

Hello,

I have this formula for row 2 to convert the month in Row 3 to the quarter in row 2. It works for q1, but not the other quarters. Any suggestions?

Here is my formula:
=CONCATENATE("Q",(ROUNDUP(MONTH(F3)/3,0)))

Thanks!
LauraMonth the Quarter.xlsx

[AlKey]

It doesn't work because MONTH() functions expects a real date in D3

Enter this date 1/1/2013 in D3 and this formula in E3 =EDATE(D3,1) and pull formula to the very end to the right.

Now your formula should work fine

=CONCATENATE("Q",(ROUNDUP(MONTH(D3)/3,0)))

[Ace_XL]

or with your existing values use

="Q"&INT((D3-1)/3)+1
or even
="Q"&CEILING(D3,3)/3

[lejanco]

Thank you!