How do I group date periods by quarter?

Ask for Help
1

How do I group date periods by quarter?

I used (if-then-else)
month =1,2,3 then Q1
month =4,5,6 then Q2
month =7,8,9 then Q3
month =10,11,12 then Q4

Is there another way?

tt
tt824×485 85.1 KB

2

A slightly modified if-then-else column is probably better:

  • If Month > 9, then Q4
  • If Month > 6, then Q3
  • If Month > 3, then Q2
  • Else Q1

If there is a possibility of empty date values, then perhaps this:

  • If Month > 9, then Q4
  • If Month > 6, then Q3
  • If Month > 3, then Q2
  • If Month > 0, then Q1
  • Else N/A
3 Likes
3

great, thanks

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.