Calculate Current Quarter

[wenjuanchen]

Hello Everyone,

I have three columns of data: quarter, month, current month. The current month value is 7, thus the current quarter value is 3. But if I want to create a new column called "Current Quarter", how do I define it?

Thank you so much.

[jrgo · Accepted solution]

Hi @wenjuanchen

This should do the trick.

CEIL([Current Month]/3)

[wenjuanchen]

Brilliant! Thank you!