Converting Fiscal Periods to quarter number

[ahuang3433]

I was trying to see if there is a good formula to convert fiscal period to quarter numbers.

It is setup this way. 201701

Wanting to return "1" for quarter.

[JieJenn]

Give this formula a try =INT((RIGHT(A1,2)-1)/3)+1. A1 is your year month value

[ahuang3433]

The problem is I want to show only 1-4 . not all numbers from 1-12. I want Jan-March to group to "1" and so on.

[JieJenn]

Post a sample file with your expected result.

[ahuang3433]

Quarter Fiscal Period
1 201701
1 201702
1 201703
2 201704
2 201705
2 201706
3 201707
3 201708
3 201709
4 201710
4 201711
4 201712

[JieJenn]

I don't think you tried the formula I posted earlier.

[ahuang3433]

Having trouble with my attachment key.

1 201701
2 201702
3 201703
4 201704
5 201705
6 201706
7 201707
8 201708
9 201709
10 201710
11 201711
12 201712

[ahuang3433]

this is what I'm getting.

Having trouble with my attachment key.

1 201701
2 201702
3 201703
4 201704
5 201705
6 201706
7 201707
8 201708
9 201709
10 201710
11 201711
12 201712

[JieJenn]

I am getting different result.

[ahuang3433]

I found the mistake. The parenthesis was in the wrong place.