Calculate Current Quarter

Question

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.

Define Current Quarter.xlsx

jrgo · Accepted Answer

Hi @wenjuanchen

This should do the trick.

CEIL([Current Month]/3)