Looking to set up Quarters, Starting in Feb not Jan

[shophoney]

Hi, I'm looking to create Quarters starting in Feb-Mar, Apr-Jun...

I have a calendar table, what formula would be best to calculate that? And should it be 2018-Q1, 2018-Q2...?

Thanks

 

[Scott Huish]

Assuming date in A1

=YEAR(EDATE(A1,-1))&"-Q"&-INT(-MONTH(EDATE(A1,-1))/3)

Copy down.

Excel 2010
	A	B
1	1/1/2018	2017-Q4
2	2/1/2018	2018-Q1
3	3/1/2018	2018-Q1
4	4/1/2018	2018-Q1
5	5/1/2018	2018-Q2
6	6/1/2018	2018-Q2
7	7/1/2018	2018-Q2
8	8/1/2018	2018-Q3
9	9/1/2018	2018-Q3
10	10/1/2018	2018-Q3
11	11/1/2018	2018-Q4
12	12/1/2018	2018-Q4
Sheet1

Cell Formulas
Range	Formula
B1	=YEAR(EDATE(A1,-1))&"-Q"&-INT(-MONTH(EDATE(A1,-1))/3)
B2	=YEAR(EDATE(A2,-1))&"-Q"&-INT(-MONTH(EDATE(A2,-1))/3)
B3	=YEAR(EDATE(A3,-1))&"-Q"&-INT(-MONTH(EDATE(A3,-1))/3)
B4	=YEAR(EDATE(A4,-1))&"-Q"&-INT(-MONTH(EDATE(A4,-1))/3)
B5	=YEAR(EDATE(A5,-1))&"-Q"&-INT(-MONTH(EDATE(A5,-1))/3)
B6	=YEAR(EDATE(A6,-1))&"-Q"&-INT(-MONTH(EDATE(A6,-1))/3)
B7	=YEAR(EDATE(A7,-1))&"-Q"&-INT(-MONTH(EDATE(A7,-1))/3)
B8	=YEAR(EDATE(A8,-1))&"-Q"&-INT(-MONTH(EDATE(A8,-1))/3)
B9	=YEAR(EDATE(A9,-1))&"-Q"&-INT(-MONTH(EDATE(A9,-1))/3)
B10	=YEAR(EDATE(A10,-1))&"-Q"&-INT(-MONTH(EDATE(A10,-1))/3)
B11	=YEAR(EDATE(A11,-1))&"-Q"&-INT(-MONTH(EDATE(A11,-1))/3)
B12	=YEAR(EDATE(A12,-1))&"-Q"&-INT(-MONTH(EDATE(A12,-1))/3)

 

[shophoney]

Will this also work in DAX. What do I copy?

 

[Scott Huish]

Oh sorry, I didn't see that this wasn't in the Excel forum.