Pivot table - change the fiscal period to start in Feb instead of Jan

[Scott_M330]

The pivot table defaults to Q1 being Jan, Feb, Mar and Q2 being Apr, May, June etc...

Is there a way to change it so that Q1 is Feb, Mar, Apr and Q2 is May, June, July etc...

My company's fiscal year starts in Feb. This is killing me in Excel...there must be a setting somewhere to tell Excel my fiscal start month is Feb.

[#2]

@Scott_M330 

Let's say you have dates in D2 and down.

Insert a new column next to column D.

In E2, enter the formula

=QUOTIENT(MONTH(EDATE(D2,-1))-1,3)+1

to return the quarter as a number 1, 2, 3, 4, or

="Q"&QUOTIENT(MONTH(EDATE(K1,-1))-1,3)+1

to return it as text Q1, Q2, Q3, Q4.

Use the new column in the pivot table.

For the fiscal year you can insert another column with formula

=YEAR(EDATE(D2,-1))

Fill down to the last data row.

[#3]

@Scott_M330 

If in Excel you work with data model, here is the pattern how to work with non-standard fiscal years Custom time-related calculations – DAX Patterns