How to calculate calendar quarter

Have to group rows by calendar quarter based on [Actual Start] date. Am trying virtual column
CONCATENATE(YEAR([Actual Start]),“Q”,CEILING(MONTH([Actual Start])/3))
but MONTH([Actual Start])/3 is giving me an integer.
Example 1/15/2019 computes to Month = 5.000
but am getting
MONTH([Actual Start])/3 = 1.000 , not 1.667

I want 5/3 = 1.667 so I can get Ceiling = 2

0 3 765
3 REPLIES 3

Use MONTH([Actual Start])/3.0

That works! Thanks.

Steve
Participant V
Top Labels in this Space